All Unit Monitors in Microsoft.SQLServer.2016.AlwaysOn.Monitoring Management Pack

 DisplayNameDescriptionIDTargetParent MonitorCategoryEnabledInstance NameCounter NameFrequencyAlert GenerateAlert SeverityAlert PriorityAlert Auto ResolveMonitor TypeRemotableAccessibilityRunAs
Microsoft.SQLServer.2016.AlwaysOn.AllAvailabilityReplicasAreConnectedAvailability Replicas Connection monitorAvailability Replicas ConnectionMicrosoft.SQLServer.2016.AlwaysOn.AllAvailabilityReplicasAreConnectedMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.AutomaticFailoverReadinessAvailability Group Automatic Failover monitorAvailability Group Automatic FailoverMicrosoft.SQLServer.2016.AlwaysOn.AutomaticFailoverReadinessMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitorAvailability Group Health PolicyTwo state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Availability Group as Facet and one of the predefined error categories as Policy Category.Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitorMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorTypeTruePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupOnlineAvailability Group Online monitorAvailability Group OnlineMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupOnlineMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitorAvailability Group Health PolicyTwo state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Availability Group as Facet and one of the predefined warning categories as Policy Category.Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitorMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorTypeTruePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaDataSynchronizationHealthAvailability Replica Data SynchronizationThis monitor rolls up the data synchronization state of all database replica in the availability replica. The monitor is unhealthy when any database replica is not in the expected data synchronization state. The monitor is healthy otherwise.Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaDataSynchronizationHealthMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitorAvailability Replica Health PolicyTwo state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Availability Replica as Facet and one of the predefined error categories as Policy Category.Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitorMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorTypeTruePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaIsConnectedAvailability Replica ConnectionThis monitor checks the connection state between availability replicas. The monitor is unhealthy when the availability replica’s connection state is DISCONNECTED. The monitor is healthy otherwise.Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaIsConnectedMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaIsJoinedAvailability Replica Join StateThis monitor checks the join state of availability replica. The monitor is unhealthy when the availability replica is added to the availability group but not joined properly. The monitor is healthy otherwise.Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaIsJoinedMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleStateAvailability Replicas Role monitorAvailability Replicas RoleMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleStateMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizationStateSynchronous Replicas Data Synchronization monitorSynchronous Replicas Data SynchronizationMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizationStateMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizingAvailability Replicas Data Synchronization monitorAvailability Replicas Data SynchronizationMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizingMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitorAvailability Replica Health PolicyTwo 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.Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitorMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorTypeTruePublic
Microsoft.SQLServer.2016.AlwaysOn.ClusterStateMonitorWSFC Cluster monitorThis monitor checks the state of Windows Server Failover Cluster (WSFC) service. The monitor is unhealthy and alert is raised when the cluster is offline or in the forced quorum state. (All availability groups hosted within this cluster are offline or the disaster recovery action is required). Monitor state is healthy when the cluster state is in the normal quorum.Microsoft.SQLServer.2016.AlwaysOn.ClusterStateMonitorMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitorDatabase Replica Health PolicyTwo 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.Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitorMicrosoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorTypeTruePublic
Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitorDatabase Replica Health PolicyTwo state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Database Replica State as Facet and one of the predefined warning categories as Policy Category.Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitorMicrosoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningUserPolicySystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorTypeTruePublic
Microsoft.SQLServer.2016.AlwaysOn.DbrDataSynchronizationStateAvailability Database Data SynchronizationThis monitor checks the data synchronization state of database replica. The monitor is unhealthy when the data synchronization state is NOT SYNCHRONIZING or the state is not SYNCHRONIZED for synchronous commit database replica.Microsoft.SQLServer.2016.AlwaysOn.DbrDataSynchronizationStateMicrosoft.SQLServer.2016.AlwaysOn.DatabaseReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.DbrJoinStateAvailability Database Join StateThis monitor checks the join state of database replica. The monitor is unhealthy when the database replica is not joined. The monitor is in healthy state otherwise.Microsoft.SQLServer.2016.AlwaysOn.DbrJoinStateMicrosoft.SQLServer.2016.AlwaysOn.DatabaseReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.DbrSuspendStateAvailability Database Suspension StateThis monitor checks the state of data movement of the database replica. The monitor is unhealthy when the data movement is suspended. The monitor is healthy otherwise.Microsoft.SQLServer.2016.AlwaysOn.DbrSuspendStateMicrosoft.SQLServer.2016.AlwaysOn.DatabaseReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.Monitor.AvailabilityDatabaseHealth.BackupStatusAvailability Database Backup StatusThe monitor checks availability of a full database backup and its age as reported by Microsoft SQL Server; it does not apply any logic regarding the replicas preferred for the backup.Microsoft.SQLServer.2016.AlwaysOn.Monitor.AvailabilityDatabaseHealth.BackupStatusMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityDatabaseHealthSystem.Health.AvailabilityStateAvailabilityHealthFalse0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.MonitorType.AvailabilityDatabaseHealth.BackupStatusTruePublicMicrosoft.SQLServer.MonitoringAccount
Microsoft.SQLServer.2016.AlwaysOn.RoleOfAvailabilityReplicaIsHealthyAvailability Replica RoleThis monitor checks the state of role of availability replica. The monitor is unhealthy when the availability replica’s role is not primary or secondary. The monitor is healthy otherwise.Microsoft.SQLServer.2016.AlwaysOn.RoleOfAvailabilityReplicaIsHealthyMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaSystem.Health.AvailabilityStateAvailabilityHealthTrue0FalseFalseMicrosoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorTypeTruePublicMicrosoft.SQLServer.MonitoringAccount