Mirroring Witness Availability Rollup

Microsoft.SQLServer.Windows.Mirroring.WitnessToWitnessRole.AvailabilityRollup (DependencyMonitor)

This monitor rolls up the Mirroring Witness availability health to the Mirroring Witness Role.

Knowledge Base article:

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:

TargetMicrosoft.SQLServer.Windows.Mirroring.WitnessRole
Parent MonitorSystem.Health.AvailabilityState
AlgorithmWorstOf
Source MonitorSystem.Health.AvailabilityState
RelationshipMicrosoft.SQLServer.Windows.Mirroring.WitnessRoleHostsWitness
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityPublic

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.Windows.Mirroring.WitnessToWitnessRole.AvailabilityRollup" Accessibility="Public" Enabled="true" Target="Microsoft.SQLServer.Windows.Mirroring.WitnessRole" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" RelationshipType="Microsoft.SQLServer.Windows.Mirroring.WitnessRoleHostsWitness" MemberMonitor="Health!System.Health.AvailabilityState">
<Category>AvailabilityHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Error</MemberUnAvailable>
</DependencyMonitor>