sys.query_store_replicas (Transact-SQL)
Applies to:
SQL Server 2022 (16.x)
Azure SQL Managed Instance
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 Azure SQL Managed Instance or Azure SQL Database. |
Remarks
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.
Permissions
Requires the VIEW DATABASE STATE
permission.
Next steps
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om