Which three are SQL Performance Analyzer capabilities t…

Which three are SQL Performance Analyzer capabilities that enable forecasting impact of system changes on a SQL workload?

Which three are SQL Performance Analyzer capabilities that enable forecasting impact of system changes on a SQL workload?

A.
measuring performance before and after the change

B.
generating a list of SQL Hints that the Optimizer will use to improve overall performance

C.
identifying the SQL statements that regressed or improved

D.
providing tuning recommendations for each SQL statement that is regressed

E.
measuring performance and comparing to industry benchmarks (TPC-C, TPC-D)

F.
measuring a change in user session logins



Leave a Reply 3

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