sys-query-store-query-hints-transact-sql.md

title	sys.query_store_query_hints (Transact-SQL)
description	The sys.query_store_query_hints system catalog view returns Query Store hints.
author	rwestMSFT
ms.author	randolphwest
ms.date	07/25/2025
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
ms.custom	ignite-2025
f1_keywords	SYS.QUERY_STORE_QUERY_HINTS QUERY_STORE_QUERY_HINTS SYS.QUERY_STORE_QUERY_HINTS_TSQL QUERY_STORE_QUERY_HINTS_TSQL
helpviewer_keywords	sys.query_store_query_hints catalog view query_store_query_hints catalog view
dev_langs	TSQL
monikerRange	=azuresqldb-current || =azuresqldb-mi-current || >=sql-server-ver16 || >=sql-server-linux-ver16 || =fabric-sqldb

sys.query_store_query_hints (Transact-SQL)

[!INCLUDE sqlserver2022-asdb-asmi-fabricsqldb]

Returns query hints from Query Store hints.

Column name	Data type	Description
query_hint_id	bigint	Unique identifier of a query hint.
query_id	bigint	Unique identifier of a query in the Query Store. Foreign key to the query_id column in sys.query_store_query.
replica_group_id	bigint	Determines the scope at which the hint is applied, as per the replica_group_id column in sys.query_store_replicas.
query_hint_text	nvarchar(max)	Hint definition in form of N'OPTION (...)
last_query_hint_failure_reason	int	Error code returned when if applying hints failed. Includes the message_id of the error message.
last_query_hint_failure_reason_desc	nvarchar(128)	Includes the error description of the error message.
query_hint_failure_count	bigint	Number of times that the query hint application failed since the query hint was created or last modified.
source	int	Source of Query Store hint: user source is zero and system-generated is non-zero.
source_desc	nvarchar(128)	Description of source of Query Store hint.
comment	nvarchar(max)	Internal use only.

Remarks

Query Store hints are created by sys.sp_query_store_set_hints and removed by sys.sp_query_store_clear_hints.

Permissions

[!INCLUDE sssql19-md] and previous versions require VIEW SERVER STATE permission on the server.

[!INCLUDE sssql22-md] and later versions require VIEW SERVER PERFORMANCE STATE permission on the server.

Examples

View Query Store hints

The following example returns existing Query Store hints for query_id 39:

SELECT query_hint_id,
       query_id,
       replica_group_id,
       query_hint_text,
       last_query_hint_failure_reason,
       last_query_hint_failure_reason_desc,
       query_hint_failure_count,
       source,
       source_desc
FROM sys.query_store_query_hints
WHERE query_id = 39;

Related content

• Query Store hints
• sys.sp_query_store_set_hints
• sys.sp_query_store_clear_hints
• sys.query_store_query (Transact-SQL)