duration | Derived Field. total_elapsed_time / 1000 | Yes - Derived | N/A |
executions | Derived Field. execution_count | Yes - Derived | N/A |
cpu_time_milliseconds | Derived Field. total_worker_time / 1000 | Yes - Derived | N/A |
physical_reads | Derived Field. total_physical_reads | Yes - Derived | N/A |
logical_reads | Derived Field. total_logical_reads | Yes - Derived | N/A |
logical_writes | Derived Field. total_logical_writes | Yes - Derived | N/A |
sql_handle | Is a token that uniquely identifies the batch or stored procedure that the query is part of. | No | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
statement_start_offset | Indicates, in bytes, beginning with 0, the starting position of the query that the row describes within the text of its batch or persisted object. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
statement_end_offset | Indicates, in bytes, starting with 0, the ending position of the query that the row describes within the text of its batch or persisted object. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
plan_generation_num | A sequence number that can be used to distinguish between instances of plans after a recompile. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
plan_handle | Is a token that uniquely identifies a query execution plan for a batch that has executed and its plan resides in the plan cache, or is currently executing. | No | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
creation_time | Time at which the plan was compiled. | No | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_execution_time | Last time at which the plan started executing. | No | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
execution_count | Number of times that the plan has been executed since it was last compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_worker_time | Total amount of CPU time, reported in microseconds (but only accurate to milliseconds), that was consumed by executions of this plan since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_worker_time | CPU time, reported in microseconds (but only accurate to milliseconds), that was consumed the last time the plan was executed. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_worker_time | Minimum CPU time, reported in microseconds (but only accurate to milliseconds), that this plan has ever consumed during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_worker_time | Maximum CPU time, reported in microseconds (but only accurate to milliseconds), that this plan has ever consumed during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_physical_reads | Total number of physical reads performed by executions of this plan since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_physical_reads | Number of physical reads performed the last time the plan was executed. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_physical_reads | Minimum number of physical reads that this plan has ever performed during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_physical_reads | Maximum number of physical reads that this plan has ever performed during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_logical_writes | Total number of logical writes performed by executions of this plan since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_logical_writes | Number of buffer pool pages dirtied during the most recently completed execution of the plan. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_logical_writes | Minimum number of logical writes that this plan has ever performed during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_logical_writes | Maximum number of logical writes that this plan has ever performed during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_logical_reads | Total number of logical reads performed by executions of this plan since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_logical_reads | Number of logical reads performed the last time the plan was executed. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_logical_reads | Minimum number of logical reads that this plan has ever performed during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_logical_reads | Maximum number of logical reads that this plan has ever performed during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_clr_time | Time, reported in microseconds (but only accurate to milliseconds), consumed inside Microsoft .NET Framework common language runtime (CLR) objects by executions of this plan since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_clr_time | Time, reported in microseconds (but only accurate to milliseconds) consumed by execution inside .NET Framework CLR objects during the last execution of this plan. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_clr_time | Minimum time, reported in microseconds (but only accurate to milliseconds), that this plan has ever consumed inside .NET Framework CLR objects during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_clr_time | Maximum time, reported in microseconds (but only accurate to milliseconds), that this plan has ever consumed inside the .NET Framework CLR during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_elapsed_time | Total elapsed time, reported in microseconds (but only accurate to milliseconds), for completed executions of this plan. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_elapsed_time | Elapsed time, reported in microseconds (but only accurate to milliseconds), for the most recently completed execution of this plan. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_elapsed_time | Minimum elapsed time, reported in microseconds (but only accurate to milliseconds), for any completed execution of this plan. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_elapsed_time | Maximum elapsed time, reported in microseconds (but only accurate to milliseconds), for any completed execution of this plan. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
query_hash | Binary hash value calculated on the query and used to identify queries with similar logic. | No | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
query_plan_hash | Binary hash value calculated on the query execution plan and used to identify similar query execution plans. | No | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_rows | Total number of rows returned by the query. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_rows | Number of rows returned by the last execution of the query. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_rows | Minimum number of rows ever returned by the query during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_rows | Maximum number of rows ever returned by the query during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
statement_sql_handle | Populated with non-NULL values only if Query Store is turned on and collecting the stats for that particular query. | No | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
statement_context_id | Populated with non-NULL values only if Query Store is turned on and collecting the stats for that particular query. | No | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_dop | The total sum of degree of parallelism this plan used since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_dop | The degree of parallelism when this plan executed last time. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_dop | The minimum degree of parallelism this plan ever used during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_dop | The maximum degree of parallelism this plan ever used during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_grant_kb | The total amount of reserved memory grant in KB this plan received since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_grant_kb | The amount of reserved memory grant in KB when this plan executed last time. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_grant_kb | The minimum amount of reserved memory grant in KB this plan ever received during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_grant_kb | The maximum amount of reserved memory grant in KB this plan ever received during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_used_grant_kb | The total amount of reserved memory grant in KB this plan used since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_used_grant_kb | The amount of used memory grant in KB when this plan executed last time. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_used_grant_kb | The minimum amount of used memory grant in KB this plan ever used during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_used_grant_kb | The maximum amount of used memory grant in KB this plan ever used during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_ideal_grant_kb | The total amount of ideal memory grant in KB this plan estimated since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_ideal_grant_kb | The amount of ideal memory grant in KB when this plan executed last time. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_ideal_grant_kb | The minimum amount of ideal memory grant in KB this plan ever estimated during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_ideal_grant_kb | The maximum amount of ideal memory grant in KB this plan ever estimated during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_reserved_threads | The total sum of reserved parallel threads this plan ever used since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_reserved_threads | The number of reserved parallel threads when this plan executed last time. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_reserved_threads | The minimum number of reserved parallel threads this plan ever used during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_reserved_threads | The maximum number of reserved parallel threads this plan ever used during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_used_threads | The total sum of used parallel threads this plan ever used since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_used_threads | The number of used parallel threads when this plan executed last time. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_used_threads | The minimum number of used parallel threads this plan ever used during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_used_threads | The maximum number of used parallel threads this plan ever used during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_columnstore_segment_reads | The total sum of columnstore segments read by the query. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_columnstore_segment_reads | The number of columnstore segments read by the last execution of the query. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_columnstore_segment_reads | The minimum number of columnstore segments ever read by the query during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_columnstore_segment_reads | The maximum number of columnstore segments ever read by the query during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_columnstore_segment_skips | The total sum of columnstore segments skipped by the query. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_columnstore_segment_skips | The number of columnstore segments skipped by the last execution of the query. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_columnstore_segment_skips | The minimum number of columnstore segments ever skipped by the query during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_columnstore_segment_skips | The maximum number of columnstore segments ever skipped by the query during one execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_spills | The total number of pages spilled by execution of this query since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_spills | The number of pages spilled the last time the query was executed. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_spills | The minimum number of pages that this query has ever spilled during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_spills | The maximum number of pages that this query has ever spilled during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
pdw_node_id | The identifier for the node that this distribution is on. | No | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
total_page_server_reads | Total number of remote page server reads performed by executions of this plan since it was compiled. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
last_page_server_reads | Number of remote page server reads performed the last time the plan was executed. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
min_page_server_reads | Minimum number of remote page server reads that this plan has ever performed during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |
max_page_server_reads | Maximum number of remote page server reads that this plan has ever performed during a single execution. | Yes | https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%3F#statement_sql_handle |