FailoverMode (Failover Mode)

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.

Note

The Failover Mode attribute in BMC ProactiveNet Performance Management is referred as FailoverMode parameter in BMC PATROL.

Default parameter attributes

Attribute

Default value

BMC PATROL properties

Application class

Command type

PSL

Platform

Microsoft Windows

Icon style

Graph

Unit

0 - Automatic Failover, 1 - Manual Failover

Border range

0-1

Alarm1 range

Undefined

Alarm2 range

Undefined

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 Replica

Key Performance Indicator

No

Monitor for abnormalities

No

Graph by default

No

Availability

No

Response time

No

Normal distribution

No

Statistical

No

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*