sys.query_store_replicas
query-store #query-store#catalog-view
Description
Contains information about Query Store replicas, when Query Store for readable secondaries enabled. You can use this information to determine what Query Store to force or unforce a plan on a secondary replica with sys.sp_query_store_set_query_hints Query Store for secondary replicas is supported starting in SQL Server 2025 (17.x) and later versions, and in Azure SQL Database.
Syntax
ON qsr.replica_group_id = qsp.replica_group_id
WHERE qsr.replica_name =
'yourSecondaryReplicaName'
;