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 | Enables or disables the workflow. | Yes |
Generates Alerts | Defines whether the workflow generates an Alert. | No |
Target | Microsoft.SQLServer.2016.Database |
Parent Monitor | Microsoft.SQLServer.2016.DatabaseUserPolicyAggregateMonitor |
Algorithm | WorstOf |
Source Monitor | Microsoft.SQLServer.2016.DBWarningUserPolicyStateMonitor |
Relationship | Microsoft.SQLServer.2016.DatabaseHostsDBWarningUserPolicy |
Category | AvailabilityHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Remotable | True |
Accessibility | Public |
<DependencyMonitor ID="Microsoft.SQLServer.2016.DatabaseWarningUserPolicyStateMonitorRollup" Accessibility="Public" Enabled="true" Target="SQL2016Core!Microsoft.SQLServer.2016.Database" ParentMonitorID="Microsoft.SQLServer.2016.DatabaseUserPolicyAggregateMonitor" Remotable="true" Priority="Normal" RelationshipType="SQL2016Core!Microsoft.SQLServer.2016.DatabaseHostsDBWarningUserPolicy" MemberMonitor="Microsoft.SQLServer.2016.DBWarningUserPolicyStateMonitor">
<Category>AvailabilityHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Warning</MemberUnAvailable>
</DependencyMonitor>