• Management Pack:  SQL Server 2012
  • MP Version:  7.0.4.0
  • Released:  4/18/2018
  • Publisher:  Microsoft

Availability Group Automatic Failover monitor Monitor

  • ID:  Microsoft.SQLServer.2012.AlwaysOn.AutomaticFailoverReadiness
  • Description:  Availability Group Automatic Failover
  • Target:  Availability Group Health
  • Enabled:  Yes

Operational States

Name State Description
Availability group is ready for automatic failover Success  
Availability group is not ready for automatic failover Error  

Overridable Parameters

Parameter Name Default Value Description Override
Interval (seconds) 900 The recurring interval of time in seconds in which to run the workflow.
Timeout (seconds) 300 Specifies the time the workflow is allowed to run before being closed and marked as failed.
Policy Name $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroupHealth"]/AvailabilityGroupName$-AlwaysOnAgAutomaticFailoverHealthPolicy  

Run As Profiles

Name
Always On Monitoring Account

Monitor Knowledgebase

Summary

This monitor checks whether the availability group has at least one secondary replica which is failover ready. The monitor is in unhealthy state and alert is raised when the failover mode of primary replica is automatic but none of secondary replica in the availability group is automatic failover ready. The monitor is healthy state when at least one secondary replica is automatic failover ready.

Causes

The availability group is not ready for automatic failover. The primary replica is configured for automatic failover; however, the secondary replica is not ready for automatic failover. The secondary replica that is configured for automatic failover might be unavailable or its data synchronization state is currently not SYNCHRONIZED.

Resolutions
  • Check if at least one secondary is configured as automatic failover. Otherwise update the configuration of a secondary replica to be automatic failover target with synchronous commit.

  • Check if the automatic failover target replica’s data synchronization state is SYNCHRONIZED through its monitor and resolve the issue at the availability replica.

External References
This monitor does not contain any external references.

See Also for SQL Server 2012 Management Pack


Downloads for SQL Server 2012 Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED