Home
  •  

Availability State for Distributed Availability Group (Windows rollup)

Microsoft.SQLServer.Windows.Rollup.DistributedAvailabilityGroup.AGToDistributedAGAvailability (DependencyMonitor)

This monitor checks if both replicas are available. The monitor becomes unhealthy when primary or secondary availability group is unhealthy. The monitor is healthy when both replicas are healthy. This monitor is a dependency (rollup) monitor.

Knowledge Base article:

Summary

This monitor checks if both replicas are available. The monitor becomes unhealthy when the primary or secondary availability group is unhealthy. The monitor is healthy when both replicas are healthy. This monitor is a dependency (rollup) monitor.

Causes

A primary or secondary availability group is unavailable.

Resolutions

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.Core.DistributedAvailabilityGroup
Parent MonitorSystem.Health.AvailabilityState
AlgorithmWorstOf
Source MonitorSystem.Health.AvailabilityState
RelationshipMicrosoft.SQLServer.Core.DistributedAvailabilityGroupContainsAvailabilityGroup
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityPublic

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.Windows.Rollup.DistributedAvailabilityGroup.AGToDistributedAGAvailability" Accessibility="Public" Enabled="true" Target="SqlCoreLib!Microsoft.SQLServer.Core.DistributedAvailabilityGroup" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" RelationshipType="SqlCoreLib!Microsoft.SQLServer.Core.DistributedAvailabilityGroupContainsAvailabilityGroup" MemberMonitor="Health!System.Health.AvailabilityState">

  <Category>AvailabilityHealth</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Warning</MemberUnAvailable>

</DependencyMonitor>