Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
sys.query_store_runtime_stats_interval (Transact-SQL)
Applies to: 👁 Image
SQL Server 2016 (13.x) and later versions 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
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)
Feedback
Was this page helpful?