sp_query_store_remove_plan (Transact-SQL)
Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance
Removes a single plan from the Query Store.
Transact-SQL syntax conventions
Syntax
sp_query_store_remove_plan [ @plan_id = ] plan_id
[ ; ]
Arguments
[ @plan_id = ] plan_id
The ID of the query plan to be removed. @plan_id is bigint, with no default.
Return code values
0
(success) or 1
(failure).
Permissions
Requires the ALTER permission on the database.
Examples
The following example returns information about the queries in the Query Store.
SELECT txt.query_text_id,
txt.query_sql_text,
pl.plan_id,
qry.*
FROM sys.query_store_plan AS pl
INNER JOIN sys.query_store_query AS qry
ON pl.query_id = qry.query_id
INNER JOIN sys.query_store_query_text AS txt
ON qry.query_text_id = txt.query_text_id;
After you identify the plan_id that you want to delete, use the following example to delete a query plan.
EXEC sp_query_store_remove_plan 3;
Related content
- sp_query_store_force_plan (Transact-SQL)
- sp_query_store_remove_query (Transact-SQL)
- sp_query_store_unforce_plan (Transact-SQL)
- sp_query_store_reset_exec_stats (Transact-SQL)
- sp_query_store_flush_db (Transact-SQL)
- Query Store Catalog Views (Transact-SQL)
- Monitoring Performance By Using the Query Store
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru