sys.query_store_runtime_stats_interval (Transact-SQL)

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

Contains information about the start and end time of each interval over which runtime execution statistics information for a query has been collected.

Column name Data type Description
runtime_stats_interval_id bigint Primary key.
start_time datetimeoffset Start time of the interval.
end_time datetimeoffset End time of the interval.
comment nvarchar(32) Always NULL.


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_runtime_stats (Transact-SQL)
sys.query_store_wait_stats (Transact-SQL)
Monitoring Performance By Using the Query Store
Catalog Views (Transact-SQL)
Query Store Stored Procedures (Transact-SQL)