Home
  •  

Criteri di integrità replica di disponibilità

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

Monitoraggio a due stati con stato critico Errore utilizzato in particolare per indicare lo stato di criteri utente personalizzati per i quali Replica di disponibilità è impostata su Facet e una delle categorie di errore predefinite è impostata su Categoria criteri.

Knowledge Base article:

Riepilogo

This monitor checks the evaluation result of policy in the SQL server instance. The monitor is healthy if the policy was evaluated successfully. Otherwise it is unhealthy.

Soluzioni

To diagnose this issue, contact the database administrator or the policy owner with the policy name. The policy owner can determine the root cause of the policy execution evaluation that resulted in an unhealthy state of the monitor.

Element properties:

TargetMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaErrorUserPolicy
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
Monitor TypeMicrosoft.SQLServer.2012.AlwaysOn.UserPolicyScriptMonitorType
RemotableTrue
AccessibilityPublic
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitor" TypeID="Microsoft.SQLServer.2012.AlwaysOn.UserPolicyScriptMonitorType" Accessibility="Public" Enabled="true" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Target="AlwaysOnDisc!Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaErrorUserPolicy" Priority="Normal">

  <Category>AvailabilityHealth</Category>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

    <Interval>900</Interval>

    <TimeoutSeconds>300</TimeoutSeconds>

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

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

  </Configuration>

</UnitMonitor>