Query Store catalog views (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

This section contains the following catalog views.

In this section

• 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_wait_stats (Transact-SQL)

• sys.query_store_runtime_stats (Transact-SQL)

• sys.query_store_runtime_stats_interval (Transact-SQL)

• sys.query_store_query_hints (Transact-SQL)

• sys.database_query_store_internal_state (Transact-SQL)

Related content

• Query Store stored procedures (Transact-SQL)
• Monitor performance by using the Query Store
• Query Store for readable secondary replicas (preview)