Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2022 (16.x)
Azure SQL Database
Azure SQL Managed Instance
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.
| 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 Azure SQL Managed Instance. |
Remarks
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.
Permissions
Requires the VIEW DATABASE STATE permission.