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

Database Replica Health Policy Monitor

  • ID:  Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitor
  • Description:  Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Database Replica State as Facet and one of the predefined error categories as Policy Category.
  • Target:  Database Replica Critical Policy
  • Enabled:  Yes

Operational States

Name State Description
Ok Success  
Error Error  

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.DatabaseReplica"]/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