1.32 HADR Availability Group Replicas

The metrics in this category provide status and health information about AlwaysOn high-availability disaster recovery availability replicas.

Evaluation and Collection Frequency — Every 30 Minutes

Table 1-40 HADR Availability Group Replicas Metrics

Metric Description

Replica ID

Availability replica unique ID.

Group ID

Availability group unique ID.

Server Name

SQL Server server/instance name hosting the replica.

Availability Mode

Replica availability mode.

  • 0 - Asynchronous Commit

  • 1 - Synchronous Commit

Availability Mode Description

Label of the replica availability mode.

Role

Current role of this replica in the availability group.

  • 0 - Resolving

  • 1 - Primary

  • 2 - Secondary

Role Description

Label of the replica role.

Connected State

Indicates whether a secondary replica is currently connected to the primary replica.

  • 0 - Disconnected

  • 1 - Connected

Connected State Description

Label of the replica connected state.

Synchronization Health

Summary of the synchronization state for the databases in the availability group.

  • 0 - Not Healthy. At least one database is not synchronizing

  • 1 - Partially Healthy. Some databases are not in the target synchronization state.

  • 2 - Healthy. All of the databases are in the target synchronization state.

Endpoint URL

Database mirroring endpoint used for synchronization.