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 Preview

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)

Next steps

Learn more about Query Store in the following articles:

• Query Store Stored Procedures (Transact-SQL)
• Monitoring Performance By Using the Query Store
• Query Store for secondary replicas