• Management Pack:  SQL Server 2012
  • MP Version:  7.0.4.0
  • Released:  4/18/2018
  • Publisher:  Microsoft

Availability Replica Health Policy Monitor

  • ID:  Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitor
  • Description:  Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Availability Replica as Facet and one of the predefined warning categories as Policy Category.
  • Target:  Availability Replica Warning Policy
  • Enabled:  Yes

Operational States

Name State Description
Ok Success  
Warning Warning  

Overridable Parameters

Parameter Name Default Value Description Override
Interval (seconds) 900 The recurring interval of time in seconds in which to run the workflow.
Timeout (seconds) 300 Specifies the time the workflow is allowed to run before being closed and marked as failed.
Policy Name $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$  

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

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.

Causes
This unit monitor does not contain any causes.
Resolutions

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 Unhealthy state of the monitor.

External References
This monitor does not contain any external references.

See Also for SQL Server 2012 Management Pack


Downloads for SQL Server 2012 Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED