Availability Group Database Performance State (rollup)

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

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

Knowledge Base article:

Summary

This monitor rolls up perfomance 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.PerformanceState
Algorithm	WorstOf
Source Monitor	System.Health.PerformanceState
Relationship	Microsoft.SQLServer.Core.AvailabilityGroupHostsAvailabilityDatabase
Category	PerformanceHealth
Enabled	True
Alert Generate	False
Alert Auto Resolve	False
Remotable	True
Accessibility	Public

Source Code:

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

  <Category>PerformanceHealth</Category>

  <Algorithm>WorstOf</Algorithm>

</DependencyMonitor>