sys-query-store-runtime-stats-interval-transact-sql.md

title	sys.query_store_runtime_stats_interval (Transact-SQL)
description	sys.query_store_runtime_stats_interval (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.date	01/23/2019
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
ms.custom	ignite-2025
f1_keywords	QUERY_STORE_RUNTIME_STATS_INTERVAL SYS.QUERY_STORE_RUNTIME_STATS_INTERVAL QUERY_STORE_RUNTIME_STATS_INTERVAL_TSQL SYS.QUERY_STORE_RUNTIME_STATS_INTERVAL_TSQL
helpviewer_keywords	sys.query_store_runtime_stats_interval catalog view query_store_runtime_stats_interval catalog view
dev_langs	TSQL
monikerRange	=azuresqldb-current || >=sql-server-2016 || =azure-sqldw-latest || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

sys.query_store_runtime_stats_interval (Transact-SQL)

[!INCLUDE sqlserver2016-asdb-asdbmi-asa-fabricsqldb]

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)