| 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.date | 10/11/2022 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | >=sql-server-ver16||>=sql-server-linux-ver16||=azuresqldb-mi-current |
[!INCLUDE sqlserver2022-asmi]
Contains information about Query Store replicas, when Query Store for secondary replicas is enabled. You can use this information to determine what replica_group_id to use when using Query Store to force or un-force a plan on a secondary replica with sys.sp_query_store_set_query_hints.
| Column name | Data type | Description |
|---|---|---|
| replica_group_id | bigint | Identifies the replica set number for this replica. |
| role_id | tinyint | 1 = Primary 2= Secondary 3=Geo-Primary 4=Geo-Secondary |
| replica_name | nvarchar(max) | Instance name of the replica in the availability group. NULL for replicas in [!INCLUDEssazuremi-md] or [!INCLUDE ssazure-sqldb]. |
This catalog view will return the same row data on all replicas. The catalog view will contain a row per replica for every role_id where it has been observed. For example, a two-replica availability group will initially contain two rows. After a failover, it will contain four rows: one row for each replica in both the primary and secondary roles.
Requires the VIEW DATABASE STATE permission.