Events
31 Mar, 11 pm - 2 Apr, 11 pm
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todaysys.query_store_runtime_stats_interval (Transact-SQL)
Applies to: 
SQL Server 2016 (13.x) and later
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
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.
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)