sys.dm_hadr_availability_replica_cluster_states (Transact-SQL)
Applies to:
SQL Server
Returns a row for each Always On availability replica (regardless of its join state) of all Always On availability groups (regardless of replica location) in the Windows Server Failover Clustering (WSFC) cluster.
Column name | Data type | Description |
---|---|---|
replica_id | uniqueidentifier | Unique identifier of the availability replica. |
replica_server_name | nvarchar(256) | Name of the instance of SQL Server hosting the replica. |
group_id | uniqueidentifier | Unique identifier of the availability group. |
join_state | tinyint | - 0 = Not joined - 1 = Joined, standalone - 2 = Joined, failover cluster instance |
join_state_desc | nvarchar(60) | - NOT_JOINED - JOINED_STANDALONE - JOINED_FCI |
Permissions
For SQL Server 2019 (15.x) and earlier versions, requires VIEW SERVER STATE permission on the server.
For SQL Server 2022 (16.x) and later versions, requires VIEW SERVER PERFORMANCE STATE permission on the server.
See also
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre