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 on Windows.
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 on Windows.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Generates Alerts | Defines whether the workflow generates an Alert. | No |
Target | Microsoft.SQLServer.Core.AvailabilityGroup |
Parent Monitor | Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState |
Algorithm | WorstOf |
Source Monitor | Microsoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate |
Relationship | Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth |
Category | AvailabilityHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Remotable | True |
Accessibility | Public |
<DependencyMonitor ID="Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState" Accessibility="Public" Enabled="true" Target="SqlCoreLib!Microsoft.SQLServer.Core.AvailabilityGroup" ParentMonitorID="SqlCoreLib!Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState" Remotable="true" Priority="Normal" RelationshipType="SqlDiscW!Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth" MemberMonitor="Microsoft.SQLServer.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate">
<Category>AvailabilityHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Warning</MemberUnAvailable>
</DependencyMonitor>