Automated backup preference | sql-server.always-on.ag.automatedBackupPreference | Preferred location for backups in this availability group | State |
Primary recovery health | sql-server.always-on.ag.primaryRecoveryHealth | Indicates the recovery health of the primary replica | State |
Secondary recovery health | sql-server.always-on.ag.secondaryRecoveryHealth | Indicates the recovery health of a secondary replica | State |
Synchronization health | sql-server.always-on.ag.synchronizationHealth | Reflects a rollup of the synchronization health of all replicas the group | State |
Availability mode | sql-server.always-on.ar.availabilityMode | The availability mode of the replica | State |
Failover mode | sql-server.always-on.ar.failoverMode | The failover mode of the replica | State |
Is replica local | sql-server.always-on.ar.isLocal | Whether the replica is local | State |
Replica role | sql-server.always-on.ar.role | Current groups role of a local replica or a connected remote replica | State |
Operational state | sql-server.always-on.ar.operationalState | Current operational state of the replica | State |
Recovery health | sql-server.always-on.ar.recoveryHealth | Rollup of the database_state column | State |
Synchronization health | sql-server.always-on.ar.synchronizationHealth | Rollup of the database synchronization state of all joined replicas and the availability mode of the replica | State |
Connected state | sql-server.always-on.ar.connectedState | Whether a secondary replica is currently connected to the primary replica | State |
Synchronization state | sql-server.always-on.db.synchronizationState | Data-movement state | State |
Synchronization health | sql-server.always-on.db.synchronizationHealth | Intersection of the synchronization state of a database that is joined to the group on the replica and the availability mode of the replica | State |
Database state | sql-server.always-on.db.state | State of the availability database | State |
Log send queue size | sql-server.always-on.db.logSendQueueSize | Amount of log records of the primary database not sent to the secondary databases | KibiByte |
Log send rate | sql-server.always-on.db.logSendRate | Average rate at which primary replica instance sends data | KiloBytePerSecond |
Redo queue size | sql-server.always-on.db.redoQueueSize | Amount of log records in the log files of the secondary replica that has not yet been redone | KiloByte |
Redo rate | sql-server.always-on.db.redoRate | Average Rate at which the log records are being redone on a given secondary database | KiloBytePerSecond |
Filestream send rate | sql-server.always-on.db.filestreamSendRate | The rate at which the filestream files are shipped to the secondary replica | KiloBytePerSecond |