| title | sys.query_store_replicas (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | The sys.query_store_replicas system view contains information about Query Store replicas. | ||||
| author | MikeRayMSFT | ||||
| ms.author | mikeray | ||||
| ms.reviewer | randolphwest | ||||
| ms.date | 10/02/2025 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| ms.custom |
|
||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | >=sql-server-ver16 || >=sql-server-linux-ver16 || =azuresqldb-current |
[!INCLUDE sqlserver2025-asdb]
Contains information about Query Store replicas, when Query Store for readable secondaries is enabled. You can use this information to determine what replica_group_id to use when using 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 [!INCLUDE sssql25-md] and later versions, and in Azure SQL Database. For complete platform support, see Query Store for secondary replicas.
| Column name | Data type | Description |
|---|---|---|
replica_group_id |
bigint | Identifies the replica set number for this replica. |
role_type |
tinyint | 1=Primary 2=Secondary 3=Geo-Primary 4=Geo-Secondary 5 or greater=Named replica |
replica_name |
nvarchar(max) | Instance name of the replica. NULL for replicas in [!INCLUDE ssazuremi-md]. |
This catalog view returns the same row data on all replicas. The catalog view contains a row per replica for every role_type where it was observed. For example, a two-replica availability group initially contains two rows. After a failover, it contains four rows: one row for each replica in both the primary and secondary roles.
Requires the VIEW DATABASE STATE permission.