Availability Group Extended Health State

Microsoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate (AggregateMonitor)

Availability Group Extended Health Aggregate State monitor.

Knowledge Base article:

Summary

This is the rollup monitor for all extended health monitors. Extended health monitors are automatically generated by discovering the existing health policies on SQL Server instances.

Overridable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Generates Alerts

Defines whether the workflow generates an Alert.

No

Rollup Algorithm

Defines the health state of the dependency rollup monitor to reflect either the least healthy state or the most healthy state of any member.

Worst state of any member

Element properties:

TargetMicrosoft.SQLServer.Windows.AvailabilityGroupHealth
Parent MonitorSystem.Health.AvailabilityState
AlgorithmWorstOf
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityPublic

Source Code:

<AggregateMonitor ID="Microsoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate" Accessibility="Public" Enabled="true" Target="SqlDiscW!Microsoft.SQLServer.Windows.AvailabilityGroupHealth" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal">
<Category>AvailabilityHealth</Category>
<Algorithm>WorstOf</Algorithm>
</AggregateMonitor>