Availability Group Database Configuration State (rollup)

Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityDbToAvailabilityGroupConfiguration (DependencyMonitor)

This monitor rolls up configuration state of all availability databases to the availability group.

Knowledge Base article:

Summary

This monitor rolls up configuration state of all availability databases to the availability group. .

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:

Target	Microsoft.SQLServer.Core.AvailabilityGroup
Parent Monitor	System.Health.ConfigurationState
Algorithm	WorstOf
Source Monitor	System.Health.ConfigurationState
Relationship	Microsoft.SQLServer.Core.AvailabilityGroupHostsAvailabilityDatabase
Category	ConfigurationHealth
Enabled	True
Alert Generate	False
Alert Auto Resolve	False
Remotable	True
Accessibility	Public

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityDbToAvailabilityGroupConfiguration" Accessibility="Public" Enabled="true" Target="Microsoft.SQLServer.Core.AvailabilityGroup" ParentMonitorID="Health!System.Health.ConfigurationState" Remotable="true" Priority="Normal" RelationshipType="Microsoft.SQLServer.Core.AvailabilityGroupHostsAvailabilityDatabase" MemberMonitor="Health!System.Health.ConfigurationState">

  <Category>ConfigurationHealth</Category>

  <Algorithm>WorstOf</Algorithm>

</DependencyMonitor>