Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

The correct answer is B. It predicts the impact of system changes on SQL workload response time. C. It provides before and after execution statistics for each SQL statement in the analysis task. SQL Performance Analyzer measures the impact of system changes both on the overall execution time of the SQL workload and on the response time of every individual SQL statement in the workload. By default, SQL Performance Analyzer uses elapsed time as a metric for

Manage Database Performance

Question

Options

AIt is integrated with the SQL Access Advisor.
BIt predicts the impact of system changes on SQL workload response time.
CIt provides before and after execution statistics for each SQL statement in the analysis task
DIt offers fine-grained analysis of all the SQL statements in the analysis task as a group.
ESQL statements that were originally run concurrently are run concurrently by SPA.

How the community answered

(29 responses)

A
7% (2)
B
72% (21)
D
3% (1)
E
17% (5)

Explanation

SQL Performance Analyzer measures the impact of system changes both on the overall execution time of the SQL workload and on the response time of every individual SQL statement in the workload. By default, SQL Performance Analyzer uses elapsed time as a metric for

Topics

#SQL Performance Analyzer#SPA#SQL tuning#execution statistics

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice