This is the rollup monitor for all extended health monitors. Extended health monitors are automatically generated by discovering existing health policies in SQL server instances. This monitor is for warning custom user policies.
This is the rollup monitor for all extended health monitors. Extended health monitors are automatically generated by discovering existing health policies in SQL server instances. This monitor is for warning custom user policies.
Name | Description | Default Value |
Enabled |
| Yes |
Generates Alerts |
| No |
Target | Microsoft.SQLServer.2014.Database |
Parent Monitor | Microsoft.SQLServer.2014.DatabaseUserPolicyAggregateMonitor |
Algorithm | WorstOf |
Source Monitor | Microsoft.SQLServer.2014.DBWarningUserPolicyStateMonitor |
Relationship | Microsoft.SQLServer.2014.DatabaseHostsDBWarningUserPolicy |
Category | AvailabilityHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Remotable | True |
Accessibility | Public |
<DependencyMonitor ID="Microsoft.SQLServer.2014.DatabaseWarningUserPolicyStateMonitorRollup" Accessibility="Public" Enabled="true" Target="SQL2014Core!Microsoft.SQLServer.2014.Database" ParentMonitorID="Microsoft.SQLServer.2014.DatabaseUserPolicyAggregateMonitor" Remotable="true" Priority="Normal" RelationshipType="SQL2014Core!Microsoft.SQLServer.2014.DatabaseHostsDBWarningUserPolicy" MemberMonitor="Microsoft.SQLServer.2014.DBWarningUserPolicyStateMonitor">
<Category>AvailabilityHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Warning</MemberUnAvailable>
</DependencyMonitor>