Synchronization Health (SynchronizationHealth)
Displays a rollup of the database synchronization state of all joined availability databases. The rollup will reflect the least healthy accumulated state the availability databases have.
- 0 = Not healthy. All databases are in the NOT SYNCHRONIZING state.
- 1 = Partially healthy. At least one database is not synchronised.
- 2 =Healthy. All databases are in the target synchronization state.
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_AON_AVAILABILITY_DATABASE_CONTAINER |
Command type | NA |
Platform | All |
Icon style | Graph |
Unit | 0-Not Healthy 1-Partially Healthy 2-Healthy |
Border range | 0 – 2 : Alarm |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | Yes |
Parameter type | Consumer |
TrueSight/ BMC Helix Operations Management properties
Property | Default value |
|---|---|
Monitor type | MS SQL Server Always-On Availability Databases |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | Yes |
Availability | Yes |
Response time | No |
Normal distribution | No |
Statistical | No |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*