Microsoft SQL Server 2016 Always On (Monitoring)

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

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

Management Pack Elements

DataSource Modules (1)

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

Unit Monitor Types (3)

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

Categories (10)

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

Aggregate Monitors (3)

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

Dependency Monitors (19)

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

Unit Monitors (21)

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

Rules (25)

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

Console Tasks (10)

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