Database Extended Health State

Microsoft.SQLServer.2016.DatabaseUserPolicyAggregateMonitor (AggregateMonitor)

Database Extended Health Aggregate State monitor

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.

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:

Target	Microsoft.SQLServer.2016.Database
Parent Monitor	System.Health.AvailabilityState
Algorithm	WorstOf
Category	AvailabilityHealth
Enabled	True
Alert Generate	False
Alert Auto Resolve	False
Remotable	True
Accessibility	Public

Source Code:

<AggregateMonitor ID="Microsoft.SQLServer.2016.DatabaseUserPolicyAggregateMonitor" Accessibility="Public" Enabled="true" Target="SQL2016Core!Microsoft.SQLServer.2016.Database" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal">

  <Category>AvailabilityHealth</Category>

  <Algorithm>WorstOf</Algorithm>

</AggregateMonitor>