Query Store catalog views (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

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