sys.query_store_runtime_stats_interval
query-store #query-store#catalog-view
Description
2016 (13.x) and later versions 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. 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)
Syntax
LEFT
JOIN sys.query_store_runtime_stats qsrs
ON qspl.plan_id = qsrs.plan_id
LEFT
JOIN sys.query_store_runtime_stats_interval qsrsi
ON qsrs.runtime_stats_interval_id = qsrsi.runtime_stats_interval_id
WHERE qspl.plan_type = 1 or qspl.plan_type = 2
ORDER
BY qspl.query_id, qsrs.last_execution_time;
GO