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

 DisplayNameDescriptionIDTargetCategoryEnabledInstance NameCounter NameFrequencyEvent_IDEvent SourceAlert GenerateAlert SeverityAlert PriorityRemotableEvent Log
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleChangedMSSQL 2014: 可用性副本角色已更改当可用性副本更改其角色时发生此错误。Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleChangedMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaEventCollectionTrue00TrueWarningNormalTrueApplication
Microsoft.SQLServer.2014.AlwaysOn.BytesReceivedFromReplicaPerSecondMSSQL 2014: 从副本接收的字节数/秒针对可用性组通过网络从该副本接收的总字节数Microsoft.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: 发送到副本的字节数/秒已排队通过网络发送到此副本的数据库消息字节数。这些字节包括可用性组中所有数据库的消息。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: 发送到传输的字节数/秒通过网络发送到副本的总字节数Microsoft.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.DatabaseReplicaRoleChangedMSSQL 2014: 数据库副本角色已更改当数据库副本更改其角色时发生此错误。Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaRoleChangedMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaEventCollectionTrue00TrueWarningNormalTrueApplication
Microsoft.SQLServer.2014.AlwaysOn.FileBytesReceivedPerSecondMSSQL 2014: 接收的文件字节数/秒每秒从该副本接收的文件流字节数。这仅在辅助副本上有效Microsoft.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: 流控制/秒每秒为此副本启用的流控制的数目Microsoft.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: 流控制时间(毫秒/秒)在上一秒内对此副本启用了流控制的毫秒数Microsoft.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: 接收的日志字节数/秒每秒从该副本接收的日志字节数。这仅在辅助副本上有效Microsoft.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: 待撤消的日志需要撤消的日志量(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: 日志发送队列此副本上日志发送队列的大小。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: 已镜像的写入事务数/秒通过同步提交处理的事务数量。将事务延迟时间除以镜像的事务数可以获取每个事务的延迟时间。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: 从副本接收的字节数/秒针对可用性组从该副本接收的总消息数Microsoft.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: 重新发送的消息数/秒每秒为发送到副本的消息获取确认的速率Microsoft.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: 恢复队列辅助副本的日志文件中尚未重做的日志记录量。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 线程的次数。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: 剩余的重做字节为完成恢复阶段而要重做的剩余的日志字节量。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: 重新完成的字节数/秒在辅助副本上重做日志记录的速率。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: 发送到副本的字节数/秒已排队通过网络发送到此副本的消息数Microsoft.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: 发送到传输的字节数/秒已通过网络发送到此副本的消息数。用于从该副本发送的所有消息(包括控制消息)的此帐户。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: 需要撤消的日志总数必须撤销的日志的总千字节数。Microsoft.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: 事务延迟时间等待辅助确认的所有事务的总时间。Microsoft.SQLServer.2014.AlwaysOn.TransactionDelayMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPerformanceCollectionTrue$Target/Property[Type="AlwaysOnDisc!Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica"]/PerformanceObjectName$:Database ReplicaTransaction Delay9000FalseTrue