Home
  •  

Availability Replicas Role

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaRoleStateRollup (DependencyMonitor)

Knowledge Base article:

Summary

This monitor rolls up the state of role of all availability replicas and checks whether any availability replica is not in a healthy role. The monitor is in unhealthy state when any availability replica is neither primary nor secondary. The monitor is healthy state otherwise.

Causes

In this availability group, at least one availability replica does not currently have the primary or secondary role.

Resolutions

Find the availability replica whose role is not primary or secondary using availability replica monitor state and resolve the issue at the availability replica.

Overridable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Generates Alerts

Defines whether the workflow generates an Alert.

No

Element properties:

TargetMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityGroup
Parent MonitorSystem.Health.AvailabilityState
AlgorithmWorstOf
Source MonitorMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaRoleState
RelationshipMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveTrue
RemotableTrue
AccessibilityPublic

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaRoleStateRollup" Accessibility="Public" Enabled="true" Target="AlwaysOnDisc!Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroup" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" RelationshipType="AlwaysOnDisc!Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth" MemberMonitor="Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaRoleState">

  <Category>AvailabilityHealth</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Warning</MemberUnAvailable>

</DependencyMonitor>