The MS SQL Availability Replicas Status attribute
group provides details about the status of the replicas in each availability
group. This attribute group is supported for SQL Server 2012
Enterprise Edition, or later.
If the SQL Server instance is
a primary replica in an availability group, the MS SQL Availability
Replicas Status Summary attribute group displays the details of all
the replicas that are present in all the availability groups. However,
if the SQL Server instance is a secondary replica in an availability
group, the MS SQL Availability Replicas Status Summary attribute group
displays the details of only those replicas that are hosted by the
local instance.
Connection State The current connection state of the availability
replica. The following values are valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value cannot be collected. |
| Not Applicable |
-2 |
The value is not supported. |
| No Data |
-3 |
No data is collected. |
| Disconnected |
1 |
The availability replica is not connected. |
| Connected |
2 |
The availability replica is connected. |
Group ID The
ID of the availability group to which the replica belongs. The
value format is an alphanumeric string with a maximum of 64 characters.
The following values are valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
Not_collected |
The value cannot be collected. |
| Not Applicable |
Not_applicable |
The value is not supported. |
| No Data |
nodata |
No data is collected. |
Group Name The
name of the availability group to which the replica belongs. The
following values are valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
Not_collected |
The value cannot be collected. |
| Not Applicable |
Not_applicable |
The value is not supported. |
Hub Timestamp The time when data is inserted at the hub.
Last Connect Error Number The last connection error number. The
following values are valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value cannot be collected. |
| Not Applicable |
-2 |
The value is not supported. |
| No Data |
-3 |
No data is collected. |
Local Indicates
whether the replica is hosted by the local instance. The following
values are valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value cannot be collected. |
| Not Applicable |
-2 |
The value is not supported. |
| No Data |
-3 |
No data is collected. |
| No |
1 |
The replica is not hosted by the local instance. |
| Yes |
2 |
The replica is hosted by the local instance. |
Operational State The current operational state of the availability
replica. The following values are valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value cannot be collected. |
| Not Applicable |
-2 |
The value is not supported. |
| No Data |
-3 |
No data is collected. |
| Pending Failover |
1 |
A failover is being processed for this availability
group. |
| Pending |
2 |
The primary replica currently cannot process
any requests because no database worker threads are available to process
the requests. |
| Online |
3 |
The availability replica is currently online. |
| Offline |
4 |
The availability replica is currently offline. |
| Failed |
5 |
The availability replica cannot process any
requests. |
| Failed No Quorum |
6 |
The local server instance node does not have
quorum. |
| Invalid |
7 |
The availability group that is associated with
the replica is offline. |
Note: This attribute shows the value No Data on the replica
that is not local.
Originnode The
key for the table view in the format serverid:hostname:MSS.
Recovery Health Indicates whether the databases that are connected
to the availability group are online or are being recovered after
a failover. The following values are valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value cannot be collected. |
| Not Applicable |
-2 |
The value is not supported. |
| No Data |
-3 |
No data is collected. |
| In Progress |
1 |
At least one database that is connected to the
availability group is not online. |
| Online |
2 |
All databases that are connected to the availability
group are online. |
Note: This attribute shows the value No Data on the replica
that is not local.
Replica ID The
ID of the replica. The value format is an alphanumeric string
with a maximum of 64 characters. The following values are valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
Not_collected |
The value cannot be collected. |
| Not Applicable |
Not_applicable |
The value is not supported. |
| No Data |
nodata |
No data is collected. |
Role Indicates
whether the replica is a primary or a secondary replica. The
following values are valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value cannot be collected. |
| Not Applicable |
-2 |
The value is not supported. |
| No Data |
-3 |
No data is collected. |
| Resolving |
1 |
The system is gathering information about the
role of the availability replica. |
| Primary |
2 |
The replica is a primary replica. |
| Secondary |
3 |
The replica is a secondary replica. |
| Invalid |
4 |
The availability group that is associated with
the replica is offline. |
Server The
name of the SQL Server.
Synchronization Health The synchronization state of all the databases
that are connected to the availability group on the availability replica. The
following values are valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value cannot be collected. |
| Not Applicable |
-2 |
The value is not supported. |
| No Data |
-3 |
No data is collected. |
| Not Healthy |
1 |
The synchronization health of all the replicas
that are connected to the availability group is not healthy. |
| Partially Healthy |
2 |
The synchronization health of at least one replica
that is connected to the availability group is not healthy. |
| Healthy |
3 |
The synchronization health of all the replicas
that are connected to the availability group is healthy. |
Total Databases The
total number of databases that are hosted by the availability replica. The
following values are valid:
| External value |
Internal value |
Description |
|---|
| Not Collected |
-1 |
The value cannot be collected. |
| Not Applicable |
-2 |
The value is not supported. |
| No Data |
-3 |
No data is collected. |