Query Store stored procedures (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later versions Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

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