Which three statements are true about performance analysis by SQL Performance Analyzer?
(Choose three.)
A.
It detects changes in SQL execution plans.
B.
It shows only the overall impact on workload.
C.
It produces results that can be used to create the SQL plan baseline.
D.
It generates recommendations to run SQL Tuning Advisor to tune regressed SQL statements.
E.
The importance of SQL statements to be analyzed is based on the size of the objects
accessed.
A is right. SPA will detect sql plan changes
B is wrong. not just the overall workload
C is right. SPA can use SQL Plan Baseline for tuning
D is right. SPA uses SQL Tuning Advisor for those regressed SQL
E is wrong. why based on size?
So A.C.D. are correct