What is SYS.DM_EXEC_QUERY_STATS DMV?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is SYS.DM_EXEC_QUERY_STATS DMV?

Rating:

The SYS.DM_EXEC_QUERY_STATS DMV is used to display the aggregate values of the performance statistics for query plans. A query plan includes the following:

• The number of times a plan is executed after it was previously compiled.


• The total amount of CPU time consumed by the previous execution of a plan.


• The total amount of CPU time consumed by the previous compilation of a plan.


• The maximum amount of CPU time taken by the compilation of a plan.


• The maximum amount of CPU time taken by the execution of a plan.

Rating: