| 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 2016: 可用性副本角色已更改 | 当可用性副本更改其角色时发生此错误。 | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleChanged | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | Application |
| MSSQL 2016: 从副本接收的字节数/秒 | 针对可用性组通过网络从该副本接收的总字节数 | Microsoft.SQLServer.2016.AlwaysOn.BytesReceivedFromReplicaPerSecond | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Bytes Received from Replica/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 发送到副本的字节数/秒 | 已排队通过网络发送到此副本的数据库消息字节数。这些字节包括可用性组中所有数据库的消息。 | Microsoft.SQLServer.2016.AlwaysOn.BytesSentToReplicaPerSecond | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Bytes Sent to Replica/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 发送到传输的字节数/秒 | 通过网络发送到副本的总字节数 | Microsoft.SQLServer.2016.AlwaysOn.BytesSentToTransportPerSecond | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Bytes Sent to Transport/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 数据库副本角色已更改 | 当数据库副本更改其角色时发生此错误。 | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaRoleChanged | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | Application |
| MSSQL 2016: 接收的文件字节数/秒 | 每秒从该副本接收的文件流字节数。这仅在辅助副本上有效 | Microsoft.SQLServer.2016.AlwaysOn.FileBytesReceivedPerSecond | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | File Bytes Received/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 流控制/秒 | 每秒为此副本启用的流控制的数目 | Microsoft.SQLServer.2016.AlwaysOn.FlowControlPerSecond | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Flow Control/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 流控制时间(毫秒/秒) | 在上一秒内对此副本启用了流控制的毫秒数 | Microsoft.SQLServer.2016.AlwaysOn.FlowControlTimeSeconds | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Flow Control Time (ms/sec) | 900 | 0 | | False | | | True | |
| MSSQL 2016: 日志应用挂起的队列 | 挂起的要应用于数据库副本的日志块数。 | Microsoft.SQLServer.2016.AlwaysOn.LogApplyPendingQueue | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Log Apply Pending Queue | 900 | 0 | | False | | | True | |
| MSSQL 2016: 日志应用就绪队列 | 挂起且已准备好应用于数据库副本的日志块数。 | Microsoft.SQLServer.2016.AlwaysOn.LogApplyReadyQueue | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Log Apply Ready Queue | 900 | 0 | | False | | | True | |
| MSSQL 2016: 接收的日志字节数/秒 | 每秒从该副本接收的日志字节数。这仅在辅助副本上有效 | Microsoft.SQLServer.2016.AlwaysOn.LogBytesReceivedPerSecond | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Log Bytes Received/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 待撤消的日志 | 需要撤消的日志量(KB)。 | Microsoft.SQLServer.2016.AlwaysOn.LogRemainingForUndo | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Log remaining for undo | 900 | 0 | | False | | | True | |
| MSSQL 2016: 日志发送队列 | 此副本上日志发送队列的大小。 | Microsoft.SQLServer.2016.AlwaysOn.LogSendQueue | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Log Send Queue | 900 | 0 | | False | | | True | |
| MSSQL 2016: 已镜像的写入事务数/秒 | 通过同步提交处理的事务数量。将事务延迟时间除以镜像的事务数可以获取每个事务的延迟时间。 | Microsoft.SQLServer.2016.AlwaysOn.MirroredWriteTransactionsPerSecond | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Mirrored Write Transactions/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 从副本接收的字节数/秒 | 针对可用性组从该副本接收的总消息数 | Microsoft.SQLServer.2016.AlwaysOn.ReceivesFromReplicaPerSecond | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Receives from Replica/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 重新发送的消息数/秒 | 每秒为发送到副本的消息获取确认的速率 | Microsoft.SQLServer.2016.AlwaysOn.RecentMessagesPerSecond | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Resent Messages/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 恢复队列 | 辅助副本的日志文件中尚未重做的日志记录量。 | Microsoft.SQLServer.2016.AlwaysOn.RecoveryQueue | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Recovery Queue | 900 | 0 | | False | | | True | |
| MSSQL 2016: 已阻塞的重做/秒 | 自该数据库进入联机状态后在该数据库中阻止 REDO 线程的次数。 | Microsoft.SQLServer.2016.AlwaysOn.RedoBlockedSec | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Redo blocked/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 剩余的重做字节 | 为完成恢复阶段而要重做的剩余的日志字节量。 | Microsoft.SQLServer.2016.AlwaysOn.RedoBytesRemaining | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Redo Bytes Remaining | 900 | 0 | | False | | | True | |
| MSSQL 2016: 重新完成的字节数/秒 | 在辅助副本上重做日志记录的速率。 | Microsoft.SQLServer.2016.AlwaysOn.RedoneBytesPerSecond | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Redone Bytes/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 发送到副本的字节数/秒 | 已排队通过网络发送到此副本的消息数 | Microsoft.SQLServer.2016.AlwaysOn.SendsToReplicaPerSecond | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Sends to Replica/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 发送到传输的字节数/秒 | 已通过网络发送到此副本的消息数。用于从该副本发送的所有消息(包括控制消息)的此帐户。 | Microsoft.SQLServer.2016.AlwaysOn.SendsToTransportPerSecond | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica"]/PerformanceObjectName$:Availability Replica | Sends to Transport/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016: 需要撤消的日志总数 | 必须撤销的日志的总千字节数。 | Microsoft.SQLServer.2016.AlwaysOn.TotalLogRequiringUndo | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Total Log requiring undo | 900 | 0 | | False | | | True | |
| MSSQL 2016: 事务延迟时间 | 等待辅助确认的所有事务的总时间。 | Microsoft.SQLServer.2016.AlwaysOn.TransactionDelay | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | PerformanceCollection | True | $Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database Replica | Transaction Delay | 900 | 0 | | False | | | True | |