All Rules in Microsoft.SQLServer.2017.AlwaysOn.Linux.Monitoring Management Pack

 DisplayNameDescriptionIDTargetCategoryEnabledInstance NameCounter NameFrequencyEvent_IDEvent SourceAlert GenerateAlert SeverityAlert PriorityRemotableEvent Log
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.BytesReceivedFromReplicaPerSecondMSSQL 2017 on Linux Always On: Bytes Received from Replica / secTotal number of bytes received from this replica over the network for the AG.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.BytesReceivedFromReplicaPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.AvailabilityReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.BytesSentToReplicaPerSecondMSSQL 2017 on Linux Always On: 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.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.BytesSentToReplicaPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.AvailabilityReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.BytesSentToTransportPerSecondMSSQL 2017 on Linux Always On: Bytes Sent to Transport / secThe total number of bytes send over the network to the replica.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.BytesSentToTransportPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.AvailabilityReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.FlowControlPerSecondMSSQL 2017 on Linux Always On: Flow Control / secNumber of flow controls enabled for this replica per second.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.FlowControlPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.AvailabilityReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.FlowControlTimeSecondsMSSQL 2017 on Linux Always On: Flow Control Time (ms/sec)The number of milliseconds flow control was enabled to this replica within the last second.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.FlowControlTimeSecondsMicrosoft.SQLServer.2017.AlwaysOn.Linux.AvailabilityReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.ReceivesFromReplicaPerSecondMSSQL 2017 on Linux Always On: Receives from Replica / secTotal number of messages received from this replica for the AG.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.ReceivesFromReplicaPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.AvailabilityReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.ResentMessagesPerSecondMSSQL 2017 on Linux Always On: Resent Messages / secThe rate per second to get acknowledgements for messages sent to the replica.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.ResentMessagesPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.AvailabilityReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.SendsToReplicaPerSecondMSSQL 2017 on Linux Always On: Sends to Replica / secNumber of messages enqueued to be send over the network to this replica.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.SendsToReplicaPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.AvailabilityReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.SendsToTransportPerSecondMSSQL 2017 on Linux Always On: 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.2017.AlwaysOn.Linux.CollectionRule.AvailabilityReplica.SendsToTransportPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.AvailabilityReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.FileBytesReceivedPerSecondMSSQL 2017 on Linux Always On: File Bytes Received / secAmount of FILESTREAM data received by the secondary replica for the secondary database in the last second.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.FileBytesReceivedPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.LogApplyPendingQueueMSSQL 2017 on Linux Always On: Log Apply Pending QueueNumber of log blocks pending to be applied to the database replica.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.LogApplyPendingQueueMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.LogApplyReadyQueueMSSQL 2017 on Linux Always On: Log Apply Ready QueueNumber of log blocks pending and ready to be applied to the database replica.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.LogApplyReadyQueueMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.LogBytesReceivedPerSecondMSSQL 2017 on Linux Always On: Log Bytes Received / secThe number of log bytes received by this replica. This is valid only on the secondary replica.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.LogBytesReceivedPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.LogRemainingForUndoMSSQL 2017 on Linux Always On: Log Remaining for undoThe amount of log that need to be undone in KB.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.LogRemainingForUndoMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.LogSendQueueMSSQL 2017 on Linux Always On: Log Send QueueThe size of the log send queue on this replica.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.LogSendQueueMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.MirroredWriteTransactionsPerSecondMSSQL 2017 on Linux Always On: Mirrored Write Transactions / secThe number of transactions processed through synchronization commits. Dividing transaction delay by mirrored transactions to get delay per transaction.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.MirroredWriteTransactionsPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.RecoveryQueueMSSQL 2017 on Linux Always On: Recovery QueueAmount of log records in the log files of the secondary replica that has not yet been redone.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.RecoveryQueueMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.RedoBlockedSecMSSQL 2017 on Linux Always On: Redo blocked / secNumber of times the REDO thread was blocked in this database since this database was brought ONLINE.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.RedoBlockedSecMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.RedoBytesRemainingMSSQL 2017 on Linux Always On: Redo Bytes RemainingThe amount of log bytes remaining to be redone to finish the reverting phase.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.RedoBytesRemainingMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.RedoneBytesPerSecondMSSQL 2017 on Linux Always On: Redone Bytes / secThe rate at which log records are redone on the secondary replica.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.RedoneBytesPerSecondMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.TotalLogRequiringUndoMSSQL 2017 on Linux Always On: Total Log requiring undoTotal kilobytes of log that must be undone.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.TotalLogRequiringUndoMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.TransactionDelayMSSQL 2017 on Linux Always On: Transaction DelayThe total time for all transactions waited on the secondary acknowledgement.Microsoft.SQLServer.2017.AlwaysOn.Linux.CollectionRule.DatabaseReplica.TransactionDelayMicrosoft.SQLServer.2017.AlwaysOn.Linux.DatabaseReplicaPerformanceCollectionTrue00FalseTrue
Microsoft.SQLServer.2017.AlwaysOn.Linux.Rule.MonitoringPoolAlertCollection.MonitoringErrorMSSQL 2017 on Linux Always On: Monitoring errorThe rule traces monitoring workflows errors and generates error alerts.Microsoft.SQLServer.2017.AlwaysOn.Linux.Rule.MonitoringPoolAlertCollection.MonitoringErrorMicrosoft.SQLServer.2017.AlwaysOn.Linux.MonitoringPoolAlertCollectionAlertTrue00TrueErrorNormalTrueOperations Manager
Microsoft.SQLServer.2017.AlwaysOn.Linux.Rule.MonitoringPoolAlertCollection.MonitoringWarningMSSQL 2017 on Linux Always On: Monitoring warningThe rule traces monitoring workflows warnings and generates error alerts.Microsoft.SQLServer.2017.AlwaysOn.Linux.Rule.MonitoringPoolAlertCollection.MonitoringWarningMicrosoft.SQLServer.2017.AlwaysOn.Linux.MonitoringPoolAlertCollectionAlertTrue00TrueWarningNormalTrueOperations Manager