Skip to content

sp-query-store-remove-query-transact-sql.md

Latest commit

 

History

History
88 lines (71 loc) · 3.46 KB

sp-query-store-remove-query-transact-sql.md

File metadata and controls

88 lines (71 loc) · 3.46 KB

title: "sp_query_store_remove_query (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/29/2016" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "system-stored-procedures" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
  • "SP_QUERY_STORE_REMOVE_QUERY"
  • "SP_QUERY_STORE_REMOVE_QUERY_TSQL"
  • "SYS.SP_QUERY_STORE_REMOVE_QUERY"
  • "SYS.SP_QUERY_STORE_REMOVE_QUERY_TSQL" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "sys.sp_query_store_remove_query"
  • "sp_query_store_remove_query" ms.assetid: cc39ca92-3cba-478e-beef-65560aa84007 caps.latest.revision: 8 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"

sp_query_store_remove_query (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx-md]

Removes the query, as well as all associated plans and runtime stats from the query store.

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
sp_query_store_remove_query [ @query_id = ] query_id [;]

Arguments

[ @query_id = ] query_id
Is the id of the query to be removed from the query store. query_id is a bigint, with no default.

Return Code Values

0 (success) or 1 (failure)

Remarks

Permissions

Requires the EXECUTE permission on the database, and DELETE permission on the query store catalog views.

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  
JOIN sys.query_store_query AS Qry  
    ON Pl.query_id = Qry.query_id  
JOIN sys.query_store_query_text AS Txt  
    ON Qry.query_text_id = Txt.query_text_id ;

After you identify the query_id that you want to delete, use the following example to delete the query.

The following example.

EXEC sp_query_store_remove_query 3;

See Also

sp_query_store_force_plan (Transact-SQL)
sp_query_store_remove_plan (Transct-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