Failover Mode (FailoverMode)
Displays the failover mode of the availability replica.
0 = Automatic Failover. The replica is a potential target for automatic failovers. Automatic failover is supported only if the availability mode is set to synchronous commit (availability_mode = 2) and the availability replica is currently synchronized.
1 = Manual Failover. A failover to a secondary replica set to manual failover must be manually initiated by the database administrator.
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_AON_AVAILABILITY_REPLICA |
Command type | NA |
Platform | All |
Icon style | Graph |
Unit | 0-Automatic Failover 1-Manual Failover |
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 | No |
Availability | No |
Response time | No |
Normal distribution | No |
Statistical | No |