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

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

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

A.
It detects changes in SQL execution plans.

B.
It produces results that can be used to create the SQL plan baseline.

C.
The importance of SQL statements is based on the size of the objects accessed.

D.
It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

E.
It shows only the overall impact on workload and not the net SQL impact on workload.



Leave a Reply 0

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