sys.query_store_runtime_stats (Transact-SQL)

APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

Contains information about the runtime execution statistics information for the query.

Column name Data type Description
runtime_stats_id bigint Identifier of the row representing runtime execution statistics for the plan_id, execution_type and runtime_stats_interval_id. It is unique only for the past runtime statistics intervals. For currently active interval there may be multiple rows representing runtime statistics for the plan referenced by plan_id, with the execution type represented by execution_type. Typically, one row represents runtime statistics that are flushed to disk, while other(s) represent in-memory state. Hence, to get actual state for every interval you need to aggregate metrics, grouping by plan_id, execution_type and runtime_stats_interval_id.
Note: Azure SQL Data Warehouse will always return zero (0).
plan_id bigint Foreign key. Joins to sys.query_store_plan (Transact-SQL).
runtime_stats_interval_id bigint Foreign key. Joins to sys.query_store_runtime_stats_interval (Transact-SQL).
execution_type tinyint Determines type of query execution:

0 - Regular execution (successfully finished)

3 - Client initiated aborted execution

4 - Exception aborted execution
execution_type_desc nvarchar(128) Textual description of the execution type field:

0 - Regular

3 - Aborted

4 - Exception
first_execution_time datetimeoffset First execution time for the query plan within the aggregation interval. This refers to the end time of the query execution.
last_execution_time datetimeoffset Last execution time for the query plan within the aggregation interval. This refers to the end time of the query execution.
count_executions bigint Total count of executions for the query plan within the aggregation interval.
avg_duration float Average duration for the query plan within the aggregation interval (reported in microseconds) .
last_duration bigint Last duration for the query plan within the aggregation interval (reported in microseconds).
min_duration bigint Minimum duration for the query plan within the aggregation interval (reported in microseconds).
max_duration bigint Maximum duration for the query plan within the aggregation interval (reported in microseconds).
stdev_duration float Duration standard deviation for the query plan within the aggregation interval (reported in microseconds).
avg_cpu_time float Average CPU time for the query plan within the aggregation interval (reported in microseconds).
Note: Azure SQL Data Warehouse will always return zero (0).
last_cpu_time bigint Last CPU time for the query plan within the aggregation interval (reported in microseconds).
Note: Azure SQL Data Warehouse will always return zero (0).
min_cpu_time bigint Minimum CPU time for the query plan within the aggregation interval (reported in microseconds).
Note: Azure SQL Data Warehouse will always return zero (0).
max_cpu_time bigint Maximum CPU time for the query plan within the aggregation interval (reported in microseconds).
Note: Azure SQL Data Warehouse will always return zero (0).
stdev_cpu_time float CPU time standard deviation for the query plan within the aggregation interval (reported in microseconds).
Note: Azure SQL Data Warehouse will always return zero (0).
avg_logical_io_reads float Average number of logical IO reads for the query plan within the aggregation interval. (expressed as a number of 8KB pages read).
Note: Azure SQL Data Warehouse will always return zero (0).
last_logical_io_reads bigint Last number of logical IO reads for the query plan within the aggregation interval. (expressed as a number of 8KB pages read).
Note: Azure SQL Data Warehouse will always return zero (0).
min_logical_io_reads bigint Minimum number of logical IO reads for the query plan within the aggregation interval. (expressed as a number of 8KB pages read).
Note: Azure SQL Data Warehouse will always return zero (0).
max_logical_io_reads bigint Maximum number of logical IO reads for the query plan within the aggregation interval.(expressed as a number of 8KB pages read).
Note: Azure SQL Data Warehouse will always return zero (0).
stdev_logical_io_reads float Number of logical IO reads standard deviation for the query plan within the aggregation interval. (expressed as a number of 8KB pages read).
Note: Azure SQL Data Warehouse will always return zero (0).
avg_logical_io_writes float Average number of logical IO writes for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
last_logical_io_writes bigint Last number of logical IO writes for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
min_logical_io_writes bigint Minimum number of logical IO writes for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
max_logical_io_writes bigint Maximum number of logical IO writes for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
stdev_logical_io_writes float Number of logical IO writes standard deviation for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
avg_physical_io_reads float Average number of physical IO reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).
Note: Azure SQL Data Warehouse will always return zero (0).
last_physical_io_reads bigint Last number of physical IO reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).
Note: Azure SQL Data Warehouse will always return zero (0).
min_physical_io_reads bigint Minimum number of physical IO reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).
Note: Azure SQL Data Warehouse will always return zero (0).
max_physical_io_reads bigint Maximum number of physical IO reads for the query plan within the aggregation interval (expressed as a number of 8KB pages read).
Note: Azure SQL Data Warehouse will always return zero (0).
stdev_physical_io_reads float Number of physical IO reads standard deviation for the query plan within the aggregation interval (expressed as a number of 8KB pages read).
Note: Azure SQL Data Warehouse will always return zero (0).
avg_clr_time float Average CLR time for the query plan within the aggregation interval (reported in microseconds).
Note: Azure SQL Data Warehouse will always return zero (0).
last_clr_time bigint Last CLR time for the query plan within the aggregation interval (reported in microseconds).
Note: Azure SQL Data Warehouse will always return zero (0).
min_clr_time bigint Minimum CLR time for the query plan within the aggregation interval (reported in microseconds).
Note: Azure SQL Data Warehouse will always return zero (0).
max_clr_time bigint Maximum CLR time for the query plan within the aggregation interval (reported in microseconds).
Note: Azure SQL Data Warehouse will always return zero (0).
stdev_clr_time float CLR time standard deviation for the query plan within the aggregation interval (reported in microseconds).
Note: Azure SQL Data Warehouse will always return zero (0).
avg_dop float Average DOP (degree of parallelism) for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
last_dop bigint Last DOP (degree of parallelism) for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
min_dop bigint Minimum DOP (degree of parallelism) for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
max_dop bigint Maximum DOP (degree of parallelism) for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
stdev_dop float DOP (degree of parallelism) standard deviation for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
avg_query_max_used_memory float Average memory grant (reported as the number of 8 KB pages) for the query plan within the aggregation interval. Always 0 for queries using natively compiled memory optimized procedures.
Note: Azure SQL Data Warehouse will always return zero (0).
last_query_max_used_memory bigint Last memory grant (reported as the number of 8 KB pages) for the query plan within the aggregation interval. Always 0 for queries using natively compiled memory optimized procedures.
Note: Azure SQL Data Warehouse will always return zero (0).
min_query_max_used_memory bigint Minimum memory grant (reported as the number of 8 KB pages) for the query plan within the aggregation interval. Always 0 for queries using natively compiled memory optimized procedures.
Note: Azure SQL Data Warehouse will always return zero (0).
max_query_max_used_memory bigint Maximum memory grant (reported as the number of 8 KB pages) for the query plan within the aggregation interval. Always 0 for queries using natively compiled memory optimized procedures.
Note: Azure SQL Data Warehouse will always return zero (0).
stdev_query_max_used_memory float Memory grant standard deviation (reported as the number of 8 KB pages) for the query plan within the aggregation interval. Always 0 for queries using natively compiled memory optimized procedures.
Note: Azure SQL Data Warehouse will always return zero (0).
avg_rowcount float Average number of returned rows for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
last_rowcount bigint Number of returned rows by the last execution of the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
min_rowcount bigint Minimum number of returned rows for the query plan within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
max_rowcount bigint Maximum number of returned rows for the query plan within the aggregation interval.
stdev_rowcount float Number of returned rows standard deviation for the query plan within the aggregation interval.
avg_log_bytes_used float Average number of bytes in the database log used by the query plan, within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
last_log_bytes_used bigint Number of bytes in the database log used by the last execution of the query plan, within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
min_log_bytes_used bigint Minimum number of bytes in the database log used by the query plan, within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
max_log_bytes_used bigint Maximum number of bytes in the database log used by the query plan, within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
stdev_log_bytes_used float Standard deviation of the number of bytes in the database log used by a query plan, within the aggregation interval.
Note: Azure SQL Data Warehouse will always return zero (0).
avg_page_server_io_reads float Average number of page server IO reads for the query plan within the aggregation interval. (expressed as a number of 8KB pages read).

Note: Applies To: Azure SQL Database Hyperscale
Azure SQL Data Warehouse, Azure SQL DB, MI (non-hyperscale) will always return zero (0).
last_page_server_io_reads bigint Last number of page server IO reads for the query plan within the aggregation interval. (expressed as a number of 8KB pages read).

Note: Applies To: Azure SQL Database Hyperscale
Azure SQL Data Warehouse, Azure SQL DB, MI (non-hyperscale) will always return zero (0).
min_page_server_io_reads bigint Minimum number of page server IO reads for the query plan within the aggregation interval. (expressed as a number of 8KB pages read).

Note: Applies To: Azure SQL Database Hyperscale
Azure SQL Data Warehouse, Azure SQL DB, MI (non-hyperscale) will always return zero (0).
max_page_server_io_reads bigint Maximum number of page server IO reads for the query plan within the aggregation interval.(expressed as a number of 8KB pages read).

Note: Applies To: Azure SQL Database Hyperscale
Azure SQL Data Warehouse, Azure SQL DB, MI (non-hyperscale) will always return zero (0).
stdev_page_server_io_reads float Number of page server IO reads standard deviation for the query plan within the aggregation interval. (expressed as a number of 8KB pages read).

Note: Applies To: Azure SQL Database Hyperscale
Azure SQL Data Warehouse, Azure SQL DB, MI (non-hyperscale) will always return zero (0).

Permissions

Requires the VIEW DATABASE STATE permission.

See Also

sys.database_query_store_options (Transact-SQL)
sys.query_context_settings (Transact-SQL)
sys.query_store_plan (Transact-SQL)
sys.query_store_query (Transact-SQL)
sys.query_store_query_text (Transact-SQL)
sys.query_store_wait_stats (Transact-SQL)
sys.query_store_runtime_stats_interval (Transact-SQL)
Monitoring Performance By Using the Query Store
Catalog Views (Transact-SQL)
Query Store Stored Procedures (Transact-SQL)