Query Plan Statistics

The metrics in this category report cached query-plan execution statistics, keyed by query and plan hash, for identifying resource-intensive statements.

Evaluation and Collection Frequency — Every 30 Minutes

Table 2-63 Query Plan Statistics Metrics

Metric	Description
Query Hash (key column)	Binary hash computed over the query, used to group statements that have the same logic.
Query Plan Hash (key column)	Binary hash computed over the query execution plan, used to group plans that have the same shape.
Query Text	Text of the SQL statement.
Batch Text	Text of the SQL batch that contains the statement.
Execution Count	Number of times the plan has been executed since it was last compiled.
Total CPU Time (ms)	Total CPU time, in milliseconds, consumed by executions of the plan.
Total Elapsed Time (ms)	Total elapsed time, in milliseconds, for completed executions of the plan.
Total Logical Reads	Total number of logical reads performed by executions of the plan.
Total Physical Reads	Total number of physical reads performed by executions of the plan.
Total Logical Writes	Total number of logical writes performed by executions of the plan.
Max Memory Grant (MB)	Maximum memory grant, in megabytes, requested by the plan.
Max Used Memory Grant (MB)	Maximum memory, in megabytes, actually used by the plan.
Total Memory Grant (MB)	Total memory, in megabytes, granted to executions of the plan.
Total Used Memory Grant (MB)	Total memory, in megabytes, actually used by executions of the plan.
Last Execution Time	Date and time at which the plan was last executed.
Creation Time	Date and time at which the plan was compiled.