query-store-stored-procedures-transact-sql.md

title	Query Store Stored Procedures (Transact-SQL)
description	Query Store stored procedures (Transact-SQL)
author	markingmyname
ms.author	maghan
ms.reviewer	randolphwest
ms.date	06/23/2025
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
ms.custom	ignite-2025
helpviewer_keywords	system stored procedures [SQL Server], Query Store stored procedures [SQL Server], Query Store Query Store [SQL Server], stored procedures
dev_langs	TSQL
monikerRange	=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

Query Store stored procedures (Transact-SQL)

[!INCLUDE sqlserver2016-asdb-asdbmi-fabricsqldb]

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