HADR Availability Group Replica Databases

The metrics in this category report the state and data-movement statistics of each availability database on each replica of an Always On availability group.

Evaluation and Collection Frequency — Every 30 Minutes

Table 2-44 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.

Database Name (key column)

Name of the availability database on the replica.

Synchronization Health Description

Text description of the database's synchronization health (for example, HEALTHY, PARTIALLY_HEALTHY, NOT_HEALTHY).

Log Send Queue (KB)

Amount of log records, in kilobytes, in the primary database's log that has not yet been sent to the secondary replica.

Redo Queue (KB)

Amount of log records, in kilobytes, in the secondary database's log that has not yet been redone.

Log Send Rate (KB/s)

Rate, in kilobytes per second, at which log records are being sent to the secondary replica.

Redo Rate (KB/s)

Rate, in kilobytes per second, at which log records are being redone on the secondary database.