Availability Group Extended Health State (Linux rollup)

Microsoft.SQLServer.Linux.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState (DependencyMonitor)

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

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 in SQL server instances on Linux.

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:

Target	Microsoft.SQLServer.Core.AvailabilityGroup
Parent Monitor	Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState
Algorithm	WorstOf
Source Monitor	Microsoft.SQLServer.Linux.Rollup.AvailabilityGroupHealth.UserPolicyAggregate
Relationship	Microsoft.SQLServer.Linux.AvailabilityGroupReferencesAvailabilityGroupHealth
Category	AvailabilityHealth
Enabled	True
Alert Generate	False
Alert Auto Resolve	True
Remotable	True
Accessibility	Public

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.Linux.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState" Accessibility="Public" Enabled="true" Target="SqlCoreLib!Microsoft.SQLServer.Core.AvailabilityGroup" ParentMonitorID="SqlCoreLib!Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState" Remotable="true" Priority="Normal" RelationshipType="SqlDiscL!Microsoft.SQLServer.Linux.AvailabilityGroupReferencesAvailabilityGroupHealth" MemberMonitor="Microsoft.SQLServer.Linux.Rollup.AvailabilityGroupHealth.UserPolicyAggregate">

  <Category>AvailabilityHealth</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Warning</MemberUnAvailable>

</DependencyMonitor>