Which three statements are true about performance analysis by SQL Performance Analyzer?

Which three statements are true about performance analysis by SQL Performance Analyzer? (Choose three.)

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *