Synchronization Health (SynchronizationHealth- AlwaysOn Availability Group Database)
Displays a rollup of the database synchronization state of all joined availability databases (also known as "database replicas") and the availability mode of the availability replica (synchronous-commit or asynchronous-commit mode). The rollup will reflect the least healthy accumulated state the databases on the availability replica.
- 0 = Not Healthy. The synchronization_state of the database is 0 (NOT SYNCHRONIZING).
- 1 = Partially Healthy. A database on a synchronous-commit availability replica is considered partially healthy if synchronization_state is 1 (SYNCHRONIZING).
- 2 = Healthy. A database on an synchronous-commit availability replica is considered healthy if synchronization_state is 2 (SYNCHRONIZED), and a database on an asynchronous-commit availability replica is considered healthy if synchronization_state is 1 (SYNCHRONIZING)
Default properties
Attribute | Default value |
|---|---|
BMC PATROL properties | |
Application class | |
Command type | PSL |
Platform | Microsoft Windows |
Icon style | Graph |
Unit | 0-Not Healthy, 1-Partially Healthy, 2-Healthy |
Border range | 0-2 |
Alarm1 range | 0- Alarm |
Alarm2 range | 1-Warn |
Scheduling (poll time) | 10 minutes |
Active at installation | Yes |
Parameter type | Consumer |
Value set by | |
BMC ProactiveNet Performance Management properties | |
Monitor type | SQL Server Always-On Availability Database |
Key Performance Indicator | Yes |
Monitor for abnormalities | No |
Graph by default | Yes |
Availability | No |
Response time | No |
Normal distribution | No |
Statistical | Yes |