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.
Returns a row for each AlwaysOn availability replica (regardless of its join state) of all AlwaysOn 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 instance 2 = Joined, failover cluster instance |
join_state_desc |
nvarchar(60) |
NOT_JOINED JOINED_STANDALONE_INSTANCE JOINED_FAILOVER_CLUSTER_INSTANCE |
Security
Permissions
Requires VIEW SERVER STATE permission on the server.