Microsoft SQL Server 2014 Always On (Monitoring)

Microsoft.SQLServer.2014.AlwaysOn.Monitoring :: 7.0.2.0 (Management Pack)

This Management Pack enables the monitoring of Microsoft SQL Server 2014 Always On functionality. It depends on the Microsoft SQL 2014 Always On (Discovery) Management Pack.

Management Pack Elements

DataSource Modules (1)

 DisplayNameIDIsolationAccessibility
Microsoft.SQLServer.2014.AlwaysOn.DataSource.BackupStatusAvailability Database Backup Status Data Source 2014Microsoft.SQLServer.2014.AlwaysOn.DataSource.BackupStatusAnyInternal

Unit Monitor Types (3)

 DisplayNameIDAccessibilitySupport Monitor Recalculate
Microsoft.SQLServer.2014.AlwaysOn.MonitorType.AvailabilityDatabaseHealth.BackupStatusMSSQL 2014: Availability Database Backup StatusMicrosoft.SQLServer.2014.AlwaysOn.MonitorType.AvailabilityDatabaseHealth.BackupStatusInternalFalse
Microsoft.SQLServer.2014.AlwaysOn.SystemPolicyScriptMonitorTypeMSSQL 2014: Two State System Policy Monitor TypeMicrosoft.SQLServer.2014.AlwaysOn.SystemPolicyScriptMonitorTypeInternalFalse
Microsoft.SQLServer.2014.AlwaysOn.UserPolicyScriptMonitorTypeMSSQL 2014: Two State User Policy Monitor TypeMicrosoft.SQLServer.2014.AlwaysOn.UserPolicyScriptMonitorTypeInternalFalse

Secure References (1)

 DisplayNameIDContextAccessibility
Microsoft.SQLServer.2014.AlwaysOn.MonitoringAccountMicrosoft SQL Server 2014 Always On Monitoring Run As ProfileMicrosoft.SQLServer.2014.AlwaysOn.MonitoringAccountSystem.EntityPublic

Categories (10)

 IDTarget
Cat.Microsoft.SQLServer.2014.AlwaysOn.ForcedFailoverForAvailabilityReplicaCat.Microsoft.SQLServer.2014.AlwaysOn.ForcedFailoverForAvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.ForcedFailoverForAvailabilityReplica
Cat.Microsoft.SQLServer.2014.AlwaysOn.ManualFailoverForAvailabilityReplicaCat.Microsoft.SQLServer.2014.AlwaysOn.ManualFailoverForAvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.ManualFailoverForAvailabilityReplica
Cat.Microsoft.SQLServer.2014.AlwaysOn.ResumeDataMovementCat.Microsoft.SQLServer.2014.AlwaysOn.ResumeDataMovementMicrosoft.SQLServer.2014.AlwaysOn.ResumeDataMovement
Cat.Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityGroupCat.Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityGroupMicrosoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityGroup
Cat.Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityReplicaCat.Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityReplica
Cat.Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForDatabaseReplicaCat.Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForDatabaseReplicaMicrosoft.SQLServer.2014.AlwaysOn.RunPowerShellForDatabaseReplica
Cat.Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityGroupCat.Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityGroupMicrosoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityGroup
Cat.Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityReplicaCat.Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityReplica
Cat.Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForDatabaseReplicaCat.Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForDatabaseReplicaMicrosoft.SQLServer.2014.AlwaysOn.RunSSMSForDatabaseReplica
Cat.Microsoft.SQLServer.2014.AlwaysOn.SuspendDataMovementCat.Microsoft.SQLServer.2014.AlwaysOn.SuspendDataMovementMicrosoft.SQLServer.2014.AlwaysOn.SuspendDataMovement

Aggregate Monitors (3)

 DisplayNameIDTargetAlgorithmCategoryEnabledAlert GenerateAccessibility
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthUserPolicyAggregateMonitorAvailability Group Extended Health StateMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthUserPolicyAggregateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthWorstOfAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaUserPolicyAggregateMonitorAvailability Replica Extended Health StateMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaUserPolicyAggregateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWorstOfAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaUserPolicyAggregateMonitorDatabase Replica Extended Health StateMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaUserPolicyAggregateMonitorMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWorstOfAvailabilityHealthTrueFalsePublic

Dependency Monitors (19)

 DisplayNameIDTargetAlgorithmSource MonitorRelationshipCategoryEnabledAlert GenerateAccessibility
Microsoft.SQLServer.2014.AlwaysOn.AllAvailabilityReplicasAreConnectedRollupAvailability Replicas Connection (rollup)Microsoft.SQLServer.2014.AlwaysOn.AllAvailabilityReplicasAreConnectedRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfMicrosoft.SQLServer.2014.AlwaysOn.AllAvailabilityReplicasAreConnectedMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AutomaticFailoverReadinessRollupAvailability Group Automatic Failover (rollup)Microsoft.SQLServer.2014.AlwaysOn.AutomaticFailoverReadinessRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfMicrosoft.SQLServer.2014.AlwaysOn.AutomaticFailoverReadinessMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueTruePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthErrorUserPolicyStateMonitorRollupAvailability Group Critical Policies (rollup)Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthErrorUserPolicyStateMonitorRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthWorstOfMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsErrorUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthWarningUserPolicyStateMonitorRollupAvailability Group Warning Policies (rollup)Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthWarningUserPolicyStateMonitorRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthWorstOfMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsWarningUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupOnlineRollupAvailability Group Online (rollup)Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupOnlineRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupOnlineMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueTruePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupUserPolicyStateMonitorRollupAvailability Group Extended Health State (rollup)Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupUserPolicyStateMonitorRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthUserPolicyAggregateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicyStateMonitorRollupAvailability Replica Critical Policies (rollup)Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicyStateMonitorRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWorstOfMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaHostsErrorUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleStateRollupAvailability Replicas Role (rollup)Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleStateRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleStateMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizationStateRollupSynchronous Replicas Data Synchronization (rollup)Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizationStateRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizationStateMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizingRollupAvailability Replicas Data Synchronization (rollup)Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizingRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizingMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicyStateMonitorRollupAvailability Replica Warning Policies (rollup)Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicyStateMonitorRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWorstOfMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaHostsWarningUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.ClusterStateMonitorRollupWSFC Cluster (rollup)Microsoft.SQLServer.2014.AlwaysOn.ClusterStateMonitorRollupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfMicrosoft.SQLServer.2014.AlwaysOn.ClusterStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealthAvailabilityHealthTrueTruePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicyStateMonitorRollupDatabase Replica Critical Policies (rollup)Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicyStateMonitorRollupMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWorstOfMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaHostsErrorUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicyStateMonitorRollupDatabase Replica Warning Policies (rollup)Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicyStateMonitorRollupMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWorstOfMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaHostsWarningUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityDatabase.BackupStatusAvailability Database Backup Status (rollup)Microsoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityDatabase.BackupStatusMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseBestOfMicrosoft.SQLServer.2014.AlwaysOn.Monitor.AvailabilityDatabaseHealth.BackupStatusMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseReferencesAvailabilityDatabaseHealthAvailabilityHealthTrueTruePublic
Microsoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupAvailabilityAvailability Databases AvailabilityMicrosoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupAvailabilityMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfSystem.Health.AvailabilityStateMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHostsAvailabilityDatabaseAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupConfigurationAvailability Databases ConfigurationMicrosoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupConfigurationMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfSystem.Health.ConfigurationStateMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHostsAvailabilityDatabaseConfigurationHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupPerformanceAvailability Databases PerformanceMicrosoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupPerformanceMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfSystem.Health.PerformanceStateMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHostsAvailabilityDatabasePerformanceHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupSecurityAvailability Databases SecurityMicrosoft.SQLServer.2014.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupSecurityMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWorstOfSystem.Health.SecurityStateMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHostsAvailabilityDatabaseSecurityHealthTrueFalsePublic

Unit Monitors (21)

 DisplayNameIDTargetCategoryEnabledAlert GenerateAccessibility
Microsoft.SQLServer.2014.AlwaysOn.AllAvailabilityReplicasAreConnectedAvailability Replicas Connection monitorMicrosoft.SQLServer.2014.AlwaysOn.AllAvailabilityReplicasAreConnectedMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AutomaticFailoverReadinessAvailability Group Automatic Failover monitorMicrosoft.SQLServer.2014.AlwaysOn.AutomaticFailoverReadinessMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitorAvailability Group Health PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupOnlineAvailability Group Online monitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupOnlineMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitorAvailability Group Health PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaDataSynchronizationHealthAvailability Replica Data SynchronizationMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaDataSynchronizationHealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitorAvailability Replica Health PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaIsConnectedAvailability Replica ConnectionMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaIsConnectedMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaIsJoinedAvailability Replica Join StateMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaIsJoinedMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleStateAvailability Replicas Role monitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleStateMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizationStateSynchronous Replicas Data Synchronization monitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizationStateMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizingAvailability Replicas Data Synchronization monitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizingMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitorAvailability Replica Health PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.ClusterStateMonitorWSFC Cluster monitorMicrosoft.SQLServer.2014.AlwaysOn.ClusterStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitorDatabase Replica Health PolicyMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitorDatabase Replica Health PolicyMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitorMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicyAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DbrDataSynchronizationStateAvailability Database Data SynchronizationMicrosoft.SQLServer.2014.AlwaysOn.DbrDataSynchronizationStateMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DbrJoinStateAvailability Database Join StateMicrosoft.SQLServer.2014.AlwaysOn.DbrJoinStateMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DbrSuspendStateAvailability Database Suspension StateMicrosoft.SQLServer.2014.AlwaysOn.DbrSuspendStateMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaAvailabilityHealthTrueFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.Monitor.AvailabilityDatabaseHealth.BackupStatusAvailability Database Backup StatusMicrosoft.SQLServer.2014.AlwaysOn.Monitor.AvailabilityDatabaseHealth.BackupStatusMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseHealthAvailabilityHealthFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.RoleOfAvailabilityReplicaIsHealthyAvailability Replica RoleMicrosoft.SQLServer.2014.AlwaysOn.RoleOfAvailabilityReplicaIsHealthyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaAvailabilityHealthTrueFalsePublic

Rules (23)

 DisplayNameIDTargetCategoryEnabledAlert Generate
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupFailedMSSQL 2014: Availability Group FailedMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupFailedMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaEventCollectionFalseTrue
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleChangedMSSQL 2014: Availability Replica Role ChangedMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleChangedMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaEventCollectionTrueTrue
Microsoft.SQLServer.2014.AlwaysOn.BytesReceivedFromReplicaPerSecondMSSQL 2014: Bytes Received from Replica / secMicrosoft.SQLServer.2014.AlwaysOn.BytesReceivedFromReplicaPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.BytesSentToReplicaPerSecondMSSQL 2014: Bytes Sent to Replica / secMicrosoft.SQLServer.2014.AlwaysOn.BytesSentToReplicaPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.BytesSentToTransportPerSecondMSSQL 2014: Bytes Sent to Transport / secMicrosoft.SQLServer.2014.AlwaysOn.BytesSentToTransportPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaRoleChangedMSSQL 2014: Database Replica Role ChangedMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaRoleChangedMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaEventCollectionTrueTrue
Microsoft.SQLServer.2014.AlwaysOn.FileBytesReceivedPerSecondMSSQL 2014: File Bytes Received / secMicrosoft.SQLServer.2014.AlwaysOn.FileBytesReceivedPerSecondMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.FlowControlPerSecondMSSQL 2014: Flow Control / secMicrosoft.SQLServer.2014.AlwaysOn.FlowControlPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.FlowControlTimeSecondsMSSQL 2014: Flow Control Time (ms/sec)Microsoft.SQLServer.2014.AlwaysOn.FlowControlTimeSecondsMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.LogBytesReceivedPerSecondMSSQL 2014: Log Bytes Received / secMicrosoft.SQLServer.2014.AlwaysOn.LogBytesReceivedPerSecondMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.LogRemainingForUndoMSSQL 2014: Log Remaining for undoMicrosoft.SQLServer.2014.AlwaysOn.LogRemainingForUndoMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.LogSendQueueMSSQL 2014: Log Send QueueMicrosoft.SQLServer.2014.AlwaysOn.LogSendQueueMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.MirroredWriteTransactionsPerSecondMSSQL 2014: Mirrored Write Transactions / secMicrosoft.SQLServer.2014.AlwaysOn.MirroredWriteTransactionsPerSecondMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.ReceivesFromReplicaPerSecondMSSQL 2014: Receives from Replica / secMicrosoft.SQLServer.2014.AlwaysOn.ReceivesFromReplicaPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.RecentMessagesPerSecondMSSQL 2014: Resent Messages / secMicrosoft.SQLServer.2014.AlwaysOn.RecentMessagesPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.RecoveryQueueMSSQL 2014: Recovery QueueMicrosoft.SQLServer.2014.AlwaysOn.RecoveryQueueMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.RedoBlockedSecMSSQL 2014: Redo blocked/secMicrosoft.SQLServer.2014.AlwaysOn.RedoBlockedSecMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.RedoBytesRemainingMSSQL 2014: Redo Bytes RemainingMicrosoft.SQLServer.2014.AlwaysOn.RedoBytesRemainingMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.RedoneBytesPerSecondMSSQL 2014: Redone Bytes / secMicrosoft.SQLServer.2014.AlwaysOn.RedoneBytesPerSecondMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.SendsToReplicaPerSecondMSSQL 2014: Sends to Replica / secMicrosoft.SQLServer.2014.AlwaysOn.SendsToReplicaPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.SendsToTransportPerSecondMSSQL 2014: Sends to Transport / secMicrosoft.SQLServer.2014.AlwaysOn.SendsToTransportPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.TotalLogRequiringUndoMSSQL 2014: Total Log requiring undoMicrosoft.SQLServer.2014.AlwaysOn.TotalLogRequiringUndoMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2014.AlwaysOn.TransactionDelayMSSQL 2014: Transaction DelayMicrosoft.SQLServer.2014.AlwaysOn.TransactionDelayMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse

Console Tasks (10)

 DisplayNameIDTargetAccessibilityEnabled
Microsoft.SQLServer.2014.AlwaysOn.ForcedFailoverForAvailabilityReplicaForced FailoverMicrosoft.SQLServer.2014.AlwaysOn.ForcedFailoverForAvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaInternalTrue
Microsoft.SQLServer.2014.AlwaysOn.ManualFailoverForAvailabilityReplicaManual FailoverMicrosoft.SQLServer.2014.AlwaysOn.ManualFailoverForAvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaInternalTrue
Microsoft.SQLServer.2014.AlwaysOn.ResumeDataMovementResume Data MovementMicrosoft.SQLServer.2014.AlwaysOn.ResumeDataMovementMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaInternalTrue
Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityGroupSQL Server PowerShellMicrosoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityGroupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupInternalTrue
Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityReplicaSQL Server PowerShellMicrosoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaInternalTrue
Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForDatabaseReplicaSQL Server PowerShellMicrosoft.SQLServer.2014.AlwaysOn.RunPowerShellForDatabaseReplicaMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaInternalTrue
Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityGroupSQL Server Management StudioMicrosoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityGroupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupInternalTrue
Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityReplicaSQL Server Management StudioMicrosoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaInternalTrue
Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForDatabaseReplicaSQL Server Management StudioMicrosoft.SQLServer.2014.AlwaysOn.RunSSMSForDatabaseReplicaMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaInternalTrue
Microsoft.SQLServer.2014.AlwaysOn.SuspendDataMovementSuspend Data MovementMicrosoft.SQLServer.2014.AlwaysOn.SuspendDataMovementMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaInternalTrue