Mirrored Database Configuration Rollup

Microsoft.SQLServer.2016.Mirroring.DatabaseToGroupConfigurationRollup (DependencyMonitor)

This monitor rolls up the Mirrored Database configuration health to the Mirroring Group.

Knowledge Base article:

Overrideable 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.2016.Mirroring.Group
Parent MonitorSystem.Health.ConfigurationState
AlgorithmWorstOf
Source MonitorSystem.Health.ConfigurationState
RelationshipMicrosoft.SQLServer.2016.Mirroring.GroupContainsDatabase
CategoryConfigurationHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityPublic

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.2016.Mirroring.DatabaseToGroupConfigurationRollup" Accessibility="Public" Enabled="true" Remotable="true" Priority="Normal" Target="SQL2016Mirroring!Microsoft.SQLServer.2016.Mirroring.Group" ParentMonitorID="Health!System.Health.ConfigurationState" RelationshipType="SQL2016Mirroring!Microsoft.SQLServer.2016.Mirroring.GroupContainsDatabase" MemberMonitor="Health!System.Health.ConfigurationState">
<Category>ConfigurationHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Error</MemberUnAvailable>
</DependencyMonitor>