Query Store stored procedures (Transact-SQL)

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

This section contains the following stored procedures used to configure the Query Store.

In this section

• sys.sp_query_store_flush_db (Transact-SQL)
• sys.sp_query_store_force_plan (Transact-SQL)
• sys.sp_query_store_remove_plan (Transact-SQL)
• sys.sp_query_store_remove_query (Transact-SQL)
• sys.sp_query_store_reset_exec_stats (Transact-SQL)
• sys.sp_query_store_unforce_plan (Transact-SQL)
• sys.sp_query_store_set_hints (Transact-SQL)
• sys.sp_query_store_clear_message_queues (Transact-SQL)

Related content

• Query Store catalog views (Transact-SQL)
• Monitor performance by using the Query Store