| | DisplayName | Description | ID | Target | Category | Enabled | Instance Name | Counter Name | Frequency | Event_ID | Event Source | Alert Generate | Alert Severity | Alert Priority | Remotable | Event Log |
|---|
 | MSSQL 2017 on Windows Always On: Bytes Received from Replica / sec | Total number of bytes received from this replica over the network for the AG. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.BytesReceivedFromReplicaPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Bytes Sent to Replica / sec | The 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.Windows.CollectionRule.AvailabilityReplica.BytesSentToReplicaPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Bytes Sent to Transport / sec | The total number of bytes send over the network to the replica. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.BytesSentToTransportPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Flow Control / sec | Number of flow controls enabled for this replica per second. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.FlowControlPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows 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.Windows.CollectionRule.AvailabilityReplica.FlowControlTimeSeconds | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Receives from Replica / sec | Total number of messages received from this replica for the AG. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.ReceivesFromReplicaPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Resent Messages / sec | The rate per second to get acknowledgements for messages sent to the replica. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.ResentMessagesPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Sends to Replica / sec | Number of messages enqueued to be send over the network to this replica. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.SendsToReplicaPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Sends to Transport / sec | Number 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.Windows.CollectionRule.AvailabilityReplica.SendsToTransportPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: File Bytes Received / sec | Amount of FILESTREAM data received by the secondary replica for the secondary database in the last second. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.FileBytesReceivedPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Log Apply Pending Queue | Number of log blocks pending to be applied to the database replica. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.LogApplyPendingQueue | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Log Apply Ready Queue | Number of log blocks pending and ready to be applied to the database replica. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.LogApplyReadyQueue | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Log Bytes Received / sec | The number of log bytes received by this replica. This is valid only on the secondary replica. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.LogBytesReceivedPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Log Remaining for undo | The amount of log that need to be undone in KB. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.LogRemainingForUndo | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Log Send Queue | The size of the log send queue on this replica. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.LogSendQueue | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Mirrored Write Transactions / sec | The number of transactions processed through synchronization commits. Dividing transaction delay by mirrored transactions to get delay per transaction. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.MirroredWriteTransactionsPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Recovery Queue | Amount of log records in the log files of the secondary replica that has not yet been redone. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.RecoveryQueue | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Redo blocked / sec | Number of times the REDO thread was blocked in this database since this database was brought ONLINE. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.RedoBlockedSec | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Redo Bytes Remaining | The amount of log bytes remaining to be redone to finish the reverting phase. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.RedoBytesRemaining | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Redone Bytes / sec | The rate at which log records are redone on the secondary replica. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.RedoneBytesPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Total Log requiring undo | Total kilobytes of log that must be undone. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.TotalLogRequiringUndo | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Transaction Delay | The total time for all transactions waited on the secondary acknowledgement. | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.TransactionDelay | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2017 on Windows Always On: Availability Replica Role Changed | This error occurs when Availability replica changes its role. | Microsoft.SQLServer.2017.AlwaysOn.Windows.EventRule.AvailabilityReplica.RoleChanged | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
| MSSQL 2017 on Windows Always On: Database Replica Role Changed | This error occurs when Database replica changes its role. | Microsoft.SQLServer.2017.AlwaysOn.Windows.EventRule.DatabaseReplica.RoleChanged | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
| MSSQL 2017 on Windows Always On: Monitoring error | The rule traces monitoring workflows errors and generates error alerts. | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rule.MonitoringPoolAlertCollection.MonitoringError | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitoringPoolAlertCollection | Alert | True | | | 0 | 0 | | True | Error | Normal | True | Operations Manager |
| MSSQL 2017 on Windows Always On: Monitoring warning | The rule traces monitoring workflows warnings and generates error alerts. | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rule.MonitoringPoolAlertCollection.MonitoringWarning | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitoringPoolAlertCollection | Alert | True | | | 0 | 0 | | True | Warning | Normal | True | Operations Manager |
Home