All Rules in Microsoft.SQLServer.2014.AlwaysOn.Monitoring Management Pack

 DisplayNameDescriptionIDTargetCategoryEnabledInstance NameCounter NameFrequencyEvent_IDEvent SourceAlert GenerateAlert SeverityAlert PriorityRemotableEvent Log
Microsoft.SQLServer.2014.AlwaysOn.BytesReceivedFromReplicaPerSecondMSSQL 2014: Bytes Received from Replica / secTotal number of bytes received from this replica over the network for the AGMicrosoft.SQLServer.2014.AlwaysOn.BytesReceivedFromReplicaPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability ReplicaBytes Received from Replica/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.BytesSentToReplicaPerSecondMSSQL 2014: Bytes Sent to Replica / secThe number of database message bytes enqueued to be send over the network to this replica. The bytes include messages for all databases in the AG.Microsoft.SQLServer.2014.AlwaysOn.BytesSentToReplicaPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability ReplicaBytes Sent to Replica/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.BytesSentToTransportPerSecondMSSQL 2014: Bytes Sent to Transport / secThe total number of bytes send over the network to the replicaMicrosoft.SQLServer.2014.AlwaysOn.BytesSentToTransportPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability ReplicaBytes Sent to Transport/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.FileBytesReceivedPerSecondMSSQL 2014: File Bytes Received / secThe number of filestream bytes received by from this replica. This is valid only on the secondaryMicrosoft.SQLServer.2014.AlwaysOn.FileBytesReceivedPerSecondMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaFile Bytes Received/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.FlowControlPerSecondMSSQL 2014: Flow Control / secNumber of flow controls enabled for this replica per secondMicrosoft.SQLServer.2014.AlwaysOn.FlowControlPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability ReplicaFlow Control/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.FlowControlTimeSecondsMSSQL 2014: Flow Control Time (ms/sec)The number of milliseconds flow control was enabled to this replica within the last secondMicrosoft.SQLServer.2014.AlwaysOn.FlowControlTimeSecondsMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability ReplicaFlow Control Time (ms/sec)9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.LogBytesReceivedPerSecondMSSQL 2014: Log Bytes Received / secThe number of log bytes received by this replica. This is valid only on the secondaryMicrosoft.SQLServer.2014.AlwaysOn.LogBytesReceivedPerSecondMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaLog Bytes Received/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.LogRemainingForUndoMSSQL 2014: Log Remaining for undoThe amount of log that need to be undone in KB.Microsoft.SQLServer.2014.AlwaysOn.LogRemainingForUndoMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaLog remaining for undo9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.LogSendQueueMSSQL 2014: Log Send QueueThe size of the log send queue on this replica.Microsoft.SQLServer.2014.AlwaysOn.LogSendQueueMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaLog Send Queue9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.MirroredWriteTransactionsPerSecondMSSQL 2014: Mirrored Write Transactions / secThe number of transactions processed through synchronization commits. Dividing transaction delay by mirrored transactions to get delay per transaction.Microsoft.SQLServer.2014.AlwaysOn.MirroredWriteTransactionsPerSecondMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaMirrored Write Transactions/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.ReceivesFromReplicaPerSecondMSSQL 2014: Receives from Replica / secTotal number of messages received from this replica for the AGMicrosoft.SQLServer.2014.AlwaysOn.ReceivesFromReplicaPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability ReplicaReceives from Replica/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.RecentMessagesPerSecondMSSQL 2014: Resent Messages / secThe rate per second to get acknowledgements for messages sent to the replicaMicrosoft.SQLServer.2014.AlwaysOn.RecentMessagesPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability ReplicaResent Messages/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.RecoveryQueueMSSQL 2014: Recovery QueueAmount of log records in the log files of the secondary replica that has not yet been redone.Microsoft.SQLServer.2014.AlwaysOn.RecoveryQueueMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaRecovery Queue9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.RedoBlockedSecMSSQL 2014: Redo blocked/secNumber of times the REDO thread was blocked in this database since this database was brought ONLINE.Microsoft.SQLServer.2014.AlwaysOn.RedoBlockedSecMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaRedo blocked/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.RedoBytesRemainingMSSQL 2014: Redo Bytes RemainingThe amount of log bytes remaining to be redone to finish the reverting phase.Microsoft.SQLServer.2014.AlwaysOn.RedoBytesRemainingMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaRedo Bytes Remaining9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.RedoneBytesPerSecondMSSQL 2014: Redone Bytes / secThe rate at which log records are redone on the secondary.Microsoft.SQLServer.2014.AlwaysOn.RedoneBytesPerSecondMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaRedone Bytes/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.SendsToReplicaPerSecondMSSQL 2014: Sends to Replica / secNumber of messages enqueued to be send over the network to this replicaMicrosoft.SQLServer.2014.AlwaysOn.SendsToReplicaPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability ReplicaSends to Replica/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.SendsToTransportPerSecondMSSQL 2014: Sends to Transport / secNumber of messages sent over the network to this replica. This account for all the messages sent from this replica including control messages.Microsoft.SQLServer.2014.AlwaysOn.SendsToTransportPerSecondMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability ReplicaSends to Transport/sec9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.TotalLogRequiringUndoMSSQL 2014: Total Log requiring undoMicrosoft.SQLServer.2014.AlwaysOn.TotalLogRequiringUndoMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaTotal Log requiring undo9000FalseTrue
Microsoft.SQLServer.2014.AlwaysOn.TransactionDelayMSSQL 2014: Transaction DelayThe total time for all transactions waited on the secondary acknowledgement.Microsoft.SQLServer.2014.AlwaysOn.TransactionDelayMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaTransaction Delay9000FalseTrue