Home
  •  

可用性副本联接状态

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaIsJoined (UnitMonitor)

Knowledge Base article:

摘要

此监视器检查可用性副本的联接状态。当可用性副本添加到可用性组但未正确联接时，该监视器将处于不正常状态。否则，监视器处于正常状态。

原因

此辅助副本未联接到可用性组。要将某一可用性副本成功联接到可用性组，联接状态必须为“已联接独立实例”(1) 或“已联接故障转移群集”(2)。

解决方法

使用 T-SQL、SQL PowerShell cmdlet 或 SSMS UI 将可用性副本联接到可用性组。

Element properties:

TargetMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplica
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
Monitor TypeMicrosoft.SQLServer.2012.AlwaysOn.SystemPolicyScriptMonitorType
RemotableTrue
AccessibilityPublic
RunAsMicrosoft.SQLServer.2012.AlwaysOn.MonitoringAccount

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaIsJoined" RunAs="Microsoft.SQLServer.2012.AlwaysOn.MonitoringAccount" TypeID="Microsoft.SQLServer.2012.AlwaysOn.SystemPolicyScriptMonitorType" Accessibility="Public" Enabled="true" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Target="AlwaysOnDisc!Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica" Priority="Normal">

  <Category>AvailabilityHealth</Category>

  <OperationalStates>

    <OperationalState ID="Success" MonitorTypeStateID="HealthState" HealthState="Success"/>

    <OperationalState ID="Critical" MonitorTypeStateID="ErrorState" HealthState="Warning"/>

  </OperationalStates>

  <Configuration>

    <Interval>900</Interval>

    <TimeoutSeconds>300</TimeoutSeconds>

    <PolicyName>$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica"]/AvailabilityGroupName$-$Target/Property[Type="System!System.Entity"]/DisplayName$-AlwaysOnArJoinStateHealthPolicy</PolicyName>

    <InstanceName>$Target/Property[Type="System!System.Entity"]/DisplayName$</InstanceName>

  </Configuration>

</UnitMonitor>