Skip to main content

SQL Server SQL Statistics

SQL statistic nameDescriptionDBmarlin collects?Doc Link
durationDerived Field. total_elapsed_time / 1000 Yes - DerivedN/A
executionsDerived Field. execution_count Yes - DerivedN/A
cpu_time_millisecondsDerived Field. total_worker_time / 1000 Yes - DerivedN/A
physical_readsDerived Field. total_physical_reads Yes - DerivedN/A
logical_readsDerived Field. total_logical_reads Yes - DerivedN/A
logical_writesDerived Field. total_logical_writes Yes - DerivedN/A
sql_handleIs 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_offsetIndicates, 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_offsetIndicates, 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_numA 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_handleIs 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_timeTime 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_timeLast 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_countNumber 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_timeTotal 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_timeCPU 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_timeMinimum 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_timeMaximum 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_readsTotal 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_readsNumber 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_readsMinimum 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_readsMaximum 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_writesTotal 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_writesNumber 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_writesMinimum 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_writesMaximum 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_readsTotal 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_readsNumber 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_readsMinimum 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_readsMaximum 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_timeTime, 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_timeTime, 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_timeMinimum 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_timeMaximum 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_timeTotal 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_timeElapsed 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_timeMinimum 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_timeMaximum 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_hashBinary 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_hashBinary 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_rowsTotal 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_rowsNumber 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_rowsMinimum 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_rowsMaximum 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_handlePopulated 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_idPopulated 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_dopThe 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_dopThe 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_dopThe 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_dopThe 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_kbThe 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_kbThe 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_kbThe 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_kbThe 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_kbThe 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_kbThe 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_kbThe 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_kbThe 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_kbThe 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_kbThe 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_kbThe 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_kbThe 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_threadsThe 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_threadsThe 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_threadsThe 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_threadsThe 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_threadsThe 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_threadsThe 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_threadsThe 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_threadsThe 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_readsThe 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_readsThe 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_readsThe 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_readsThe 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_skipsThe 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_skipsThe 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_skipsThe 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_skipsThe 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_spillsThe 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_spillsThe 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_spillsThe 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_spillsThe 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_idThe 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_readsTotal 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_readsNumber 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_readsMinimum 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_readsMaximum 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

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.