Connection State (ConnectionState)
Displays whether a secondary replica is currently connected to the primary replica.
- 0 = Disconnected.The response of an availability replica to the DISCONNECTED state depends on its role, as follows:
- On the primary replica, if a secondary replica is disconnected, its secondary databases are marked as NOT SYNCHRONIZED on the primary replica, which waits for the secondary to reconnect.
- On a secondary replica, upon detecting that it is disconnected, the secondary replica attempts to reconnect to the primary replica.
- 1 = Connected
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_AON_AVAILABILITY_REPLICA |
Command type | NA |
Platform | All |
Icon style | Graph |
Unit | 0-Disconnected 1-Connected |
Border range | 0 – 1: Alarm |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | No |
Parameter type | Consumer |
TrueSight/ BMC Helix Operations Management properties
Property | Default value |
|---|---|
Monitor type | MS SQL Server Always-On Availability Replica |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | Yes |
Availability | No |
Response time | No |
Normal distribution | No |
Statistical | Yes |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*