Home
  •  

Database Warning Policies

Microsoft.SQLServer.2012.DatabaseWarningUserPolicyStateMonitorRollup (DependencyMonitor)

Database Health Warning Custom User Policies 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.

Element properties:

TargetMicrosoft.SQLServer.2012.Database
Parent MonitorMicrosoft.SQLServer.2012.DatabaseUserPolicyAggregateMonitor
AlgorithmWorstOf
Source MonitorMicrosoft.SQLServer.2012.DBWarningUserPolicyStateMonitor
RelationshipMicrosoft.SQLServer.2012.DatabaseHostsDBWarningUserPolicy
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityPublic

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.2012.DatabaseWarningUserPolicyStateMonitorRollup" Accessibility="Public" Enabled="true" Target="SQL2012Core!Microsoft.SQLServer.2012.Database" ParentMonitorID="Microsoft.SQLServer.2012.DatabaseUserPolicyAggregateMonitor" Remotable="true" Priority="Normal" RelationshipType="SQL2012Core!Microsoft.SQLServer.2012.DatabaseHostsDBWarningUserPolicy" MemberMonitor="Microsoft.SQLServer.2012.DBWarningUserPolicyStateMonitor">

  <Category>AvailabilityHealth</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Warning</MemberUnAvailable>

</DependencyMonitor>