| 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 2014: Bytes Received from Replica / sec | Total number of bytes received from this replica over the network for the AG | Microsoft.SQLServer.2014.AlwaysOn.BytesReceivedFromReplicaPerSecond | Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Bytes Received from Replica/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: 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.2014.AlwaysOn.BytesSentToReplicaPerSecond | Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Bytes Sent to Replica/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: Bytes Sent to Transport / sec | The total number of bytes send over the network to the replica | Microsoft.SQLServer.2014.AlwaysOn.BytesSentToTransportPerSecond | Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Bytes Sent to Transport/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: File Bytes Received / sec | The number of filestream bytes received by from this replica. This is valid only on the secondary | Microsoft.SQLServer.2014.AlwaysOn.FileBytesReceivedPerSecond | Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | File Bytes Received/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: Flow Control / sec | Number of flow controls enabled for this replica per second | Microsoft.SQLServer.2014.AlwaysOn.FlowControlPerSecond | Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Flow Control/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: Flow Control Time (ms/sec) | The number of milliseconds flow control was enabled to this replica within the last second | Microsoft.SQLServer.2014.AlwaysOn.FlowControlTimeSeconds | Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Flow Control Time (ms/sec) | 900 | 0 | | False | | | True | |
| MSSQL 2014: Log Bytes Received / sec | The number of log bytes received by this replica. This is valid only on the secondary | Microsoft.SQLServer.2014.AlwaysOn.LogBytesReceivedPerSecond | Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Log Bytes Received/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: Log Remaining for undo | The amount of log that need to be undone in KB. | Microsoft.SQLServer.2014.AlwaysOn.LogRemainingForUndo | Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Log remaining for undo | 900 | 0 | | False | | | True | |
| MSSQL 2014: Log Send Queue | The size of the log send queue on this replica. | Microsoft.SQLServer.2014.AlwaysOn.LogSendQueue | Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Log Send Queue | 900 | 0 | | False | | | True | |
| MSSQL 2014: 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.2014.AlwaysOn.MirroredWriteTransactionsPerSecond | Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Mirrored Write Transactions/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: Receives from Replica / sec | Total number of messages received from this replica for the AG | Microsoft.SQLServer.2014.AlwaysOn.ReceivesFromReplicaPerSecond | Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Receives from Replica/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: Resent Messages / sec | The rate per second to get acknowledgements for messages sent to the replica | Microsoft.SQLServer.2014.AlwaysOn.RecentMessagesPerSecond | Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Resent Messages/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: Recovery Queue | Amount of log records in the log files of the secondary replica that has not yet been redone. | Microsoft.SQLServer.2014.AlwaysOn.RecoveryQueue | Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Recovery Queue | 900 | 0 | | False | | | True | |
| MSSQL 2014: Redo blocked/sec | Number of times the REDO thread was blocked in this database since this database was brought ONLINE. | Microsoft.SQLServer.2014.AlwaysOn.RedoBlockedSec | Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Redo blocked/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: Redo Bytes Remaining | The amount of log bytes remaining to be redone to finish the reverting phase. | Microsoft.SQLServer.2014.AlwaysOn.RedoBytesRemaining | Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Redo Bytes Remaining | 900 | 0 | | False | | | True | |
| MSSQL 2014: Redone Bytes / sec | The rate at which log records are redone on the secondary. | Microsoft.SQLServer.2014.AlwaysOn.RedoneBytesPerSecond | Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Redone Bytes/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: Sends to Replica / sec | Number of messages enqueued to be send over the network to this replica | Microsoft.SQLServer.2014.AlwaysOn.SendsToReplicaPerSecond | Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Sends to Replica/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: 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.2014.AlwaysOn.SendsToTransportPerSecond | Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Sends to Transport/sec | 900 | 0 | | False | | | True | |
| MSSQL 2014: Total Log requiring undo | | Microsoft.SQLServer.2014.AlwaysOn.TotalLogRequiringUndo | Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Total Log requiring undo | 900 | 0 | | False | | | True | |
| MSSQL 2014: Transaction Delay | The total time for all transactions waited on the secondary acknowledgement. | Microsoft.SQLServer.2014.AlwaysOn.TransactionDelay | Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Transaction Delay | 900 | 0 | | False | | | True | |