此监视器将汇总所有可用性副本的连接状态,并且检查是否任何可用性副本处于 DISCONNECTED 状态。当任何可用性副本处于 DISCONNECTED 状态时,此监视器处于不正常状态。否则,监视器处于正常状态。
在此可用性组中,至少一个辅助副本未连接到主副本。连接状态为 DISCONNECTED。
使用可用性副本监视器状态查找处于 DISCONNECTED 状态的可用性副本,然后解决该可用性副本上的问题。
Target | Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroup |
Parent Monitor | System.Health.AvailabilityState |
Algorithm | WorstOf |
Source Monitor | Microsoft.SQLServer.2012.AlwaysOn.AllAvailabilityReplicasAreConnected |
Relationship | Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth |
Category | AvailabilityHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Remotable | True |
Accessibility | Public |
<DependencyMonitor ID="Microsoft.SQLServer.2012.AlwaysOn.AllAvailabilityReplicasAreConnectedRollup" Accessibility="Public" Enabled="true" Target="AlwaysOnDisc!Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroup" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" RelationshipType="AlwaysOnDisc!Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth" MemberMonitor="Microsoft.SQLServer.2012.AlwaysOn.AllAvailabilityReplicasAreConnected">
<Category>AvailabilityHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Warning</MemberUnAvailable>
</DependencyMonitor>