Microsoft SQL Server 2012 Always On (Monitoring)

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

Microsoft SQL Server 2012 Always On Monitoring Management Pack. This management pack will discover and monitor Microsoft SQL Server 2012 Always On.

Summary

This management pack contains monitors, rules, alerts and other classes for gathering and display health of Always On objects.

Management Pack Elements

DataSource Modules (1)

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

Unit Monitor Types (3)

 DisplayNameIDAccessibilitySupport Monitor Recalculate
Microsoft.SQLServer.2012.AlwaysOn.MonitorType.AvailabilityDatabaseHealth.BackupStatusMSSQL 2012: Availaility Database Backup StatusMicrosoft.SQLServer.2012.AlwaysOn.MonitorType.AvailabilityDatabaseHealth.BackupStatusInternalFalse
Microsoft.SQLServer.2012.AlwaysOn.SystemPolicyScriptMonitorTypeMSSQL 2012: Two State System Policy Monitor TypeMicrosoft.SQLServer.2012.AlwaysOn.SystemPolicyScriptMonitorTypePublicFalse
Microsoft.SQLServer.2012.AlwaysOn.UserPolicyScriptMonitorTypeMSSQL 2012: Two State User Policy Monitor TypeMicrosoft.SQLServer.2012.AlwaysOn.UserPolicyScriptMonitorTypePublicFalse

Secure References (1)

 DisplayNameIDContextAccessibility
Microsoft.SQLServer.2012.AlwaysOn.MonitoringAccountAlways On Monitoring AccountMicrosoft.SQLServer.2012.AlwaysOn.MonitoringAccountSystem.EntityPublic

Categories (10)

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

Aggregate Monitors (3)

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

Dependency Monitors (19)

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

Unit Monitors (21)

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

Rules (23)

 DisplayNameIDTargetCategoryEnabledAlert Generate
Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroupFailedMSSQL 2012: Availability Group FailedMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityGroupFailedMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaEventCollectionFalseTrue
Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaRoleChangedMSSQL 2012: Availability Replica Role ChangedMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaRoleChangedMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaEventCollectionTrueTrue
Microsoft.SQLServer.2012.AlwaysOn.BytesReceivedFromReplicaPerSecondBytes Received from Replica / secMicrosoft.SQLServer.2012.AlwaysOn.BytesReceivedFromReplicaPerSecondMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.BytesSentToReplicaPerSecondBytes Sent to Replica / secMicrosoft.SQLServer.2012.AlwaysOn.BytesSentToReplicaPerSecondMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.BytesSentToTransportPerSecondBytes Sent to Transport / secMicrosoft.SQLServer.2012.AlwaysOn.BytesSentToTransportPerSecondMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplicaRoleChangedMSSQL 2012: Database Replica Role ChangedMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaRoleChangedMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaEventCollectionTrueTrue
Microsoft.SQLServer.2012.AlwaysOn.FileBytesReceivedPerSecondFile Bytes Received / secMicrosoft.SQLServer.2012.AlwaysOn.FileBytesReceivedPerSecondMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.FlowControlPerSecondFlow Control / secMicrosoft.SQLServer.2012.AlwaysOn.FlowControlPerSecondMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.FlowControlTimeSecondsFlow Control TimeMicrosoft.SQLServer.2012.AlwaysOn.FlowControlTimeSecondsMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.LogBytesReceivedPerSecondLog Bytes Received / secMicrosoft.SQLServer.2012.AlwaysOn.LogBytesReceivedPerSecondMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.LogRemainingForUndoLog Remaining for undoMicrosoft.SQLServer.2012.AlwaysOn.LogRemainingForUndoMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.LogSendQueueLog Send QueueMicrosoft.SQLServer.2012.AlwaysOn.LogSendQueueMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.MirroredWriteTransactionsPerSecondMirrored Write Transactions / secMicrosoft.SQLServer.2012.AlwaysOn.MirroredWriteTransactionsPerSecondMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.ReceivesFromReplicaPerSecondReceives from Replica / secMicrosoft.SQLServer.2012.AlwaysOn.ReceivesFromReplicaPerSecondMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.RecentMessagesPerSecondResent Messages / secMicrosoft.SQLServer.2012.AlwaysOn.RecentMessagesPerSecondMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.RecoveryQueueRecovery QueueMicrosoft.SQLServer.2012.AlwaysOn.RecoveryQueueMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.RedoBlockedSecRedo blocked/secMicrosoft.SQLServer.2012.AlwaysOn.RedoBlockedSecMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.RedoBytesRemainingRedo Bytes RemainingMicrosoft.SQLServer.2012.AlwaysOn.RedoBytesRemainingMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.RedoneBytesPerSecondRedone Bytes / secMicrosoft.SQLServer.2012.AlwaysOn.RedoneBytesPerSecondMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.SendsToReplicaPerSecondSends to Replica / secMicrosoft.SQLServer.2012.AlwaysOn.SendsToReplicaPerSecondMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.SendsToTransportPerSecondSends to Transport / secMicrosoft.SQLServer.2012.AlwaysOn.SendsToTransportPerSecondMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.TotalLogRequiringUndoTotal Log requiring undoMicrosoft.SQLServer.2012.AlwaysOn.TotalLogRequiringUndoMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse
Microsoft.SQLServer.2012.AlwaysOn.TransactionDelayTransaction DelayMicrosoft.SQLServer.2012.AlwaysOn.TransactionDelayMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceCollectionTrueFalse

Console Tasks (10)

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

Folder Items (2)

 DisplayNameIDFolderNameElementID
Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceViewAvailability Replica PerformanceMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceViewMicrosoft.SQLServer.2012.AlwaysOn.PerformanceFolderMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceView
Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceViewDatabase Replica PerformanceMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceViewMicrosoft.SQLServer.2012.AlwaysOn.PerformanceFolderMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceView

Views (2)

 DisplayNameIDTargetTypeAccessibilityVisible
Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceViewAvailability Replica PerformanceMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceViewMicrosoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaMicrosoft.SystemCenter.PerformanceViewTypeInternalTrue
Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceViewDatabase Replica PerformanceMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceViewMicrosoft.SQLServer.2012.AlwaysOn.DatabaseReplicaMicrosoft.SystemCenter.PerformanceViewTypeInternalTrue