title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | dev_langs | monikerRange | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Query Store stored procedures (Transact-SQL) |
Query Store stored procedures (Transact-SQL) |
markingmyname |
maghan |
randolphwest |
08/21/2024 |
sql |
system-objects |
reference |
|
|
=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current |
[!INCLUDE sqlserver2016-asdb-asdbmi]
This section contains the following stored procedures used to configure the Query Store.
- 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)