sys.query_store_runtime_stats_interval (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later versions Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL database in Microsoft Fabric

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.

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_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)