Microsoft SQL Server 2016 Always On (Monitoring)语言包

Microsoft.SQLServer.2016.AlwaysOn.Monitoring :: 6.7.15.0 (Management Pack)

此管理包将提供 Microsoft SQL Server 2016 Always On 监视功能。依赖于 Microsoft SQL 2016 Always On (Discovery)管理包。

Management Pack Elements

Show Management Pack References

TypeDefinitions

UnitMonitorType (2)

Categories

Category (10)

Monitoring

Monitors

AggregateMonitor (3)
DependencyMonitor (14)
UnitMonitor (20)

Rule (24)

Presentation

ConsoleTask (10)

Unit Monitor Types (2)

	DisplayName	ID	Accessibility	Support Monitor Recalculate
	MSSQL 2016: 两状态系统策略监视器类型	Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType	Internal	False
	MSSQL 2016: 两状态用户策略监视器类型	Microsoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorType	Internal	False

Categories (10)

	ID	Target
	Cat.Microsoft.SQLServer.2016.AlwaysOn.ForcedFailoverForAvailabilityReplica	Microsoft.SQLServer.2016.AlwaysOn.ForcedFailoverForAvailabilityReplica
	Cat.Microsoft.SQLServer.2016.AlwaysOn.ManualFailoverForAvailabilityReplica	Microsoft.SQLServer.2016.AlwaysOn.ManualFailoverForAvailabilityReplica
	Cat.Microsoft.SQLServer.2016.AlwaysOn.ResumeDataMovement	Microsoft.SQLServer.2016.AlwaysOn.ResumeDataMovement
	Cat.Microsoft.SQLServer.2016.AlwaysOn.RunPowerShellForAvailabilityGroup	Microsoft.SQLServer.2016.AlwaysOn.RunPowerShellForAvailabilityGroup
	Cat.Microsoft.SQLServer.2016.AlwaysOn.RunPowerShellForAvailabilityReplica	Microsoft.SQLServer.2016.AlwaysOn.RunPowerShellForAvailabilityReplica
	Cat.Microsoft.SQLServer.2016.AlwaysOn.RunPowerShellForDatabaseReplica	Microsoft.SQLServer.2016.AlwaysOn.RunPowerShellForDatabaseReplica
	Cat.Microsoft.SQLServer.2016.AlwaysOn.RunSSMSForAvailabilityGroup	Microsoft.SQLServer.2016.AlwaysOn.RunSSMSForAvailabilityGroup
	Cat.Microsoft.SQLServer.2016.AlwaysOn.RunSSMSForAvailabilityReplica	Microsoft.SQLServer.2016.AlwaysOn.RunSSMSForAvailabilityReplica
	Cat.Microsoft.SQLServer.2016.AlwaysOn.RunSSMSForDatabaseReplica	Microsoft.SQLServer.2016.AlwaysOn.RunSSMSForDatabaseReplica
	Cat.Microsoft.SQLServer.2016.AlwaysOn.SuspendDataMovement	Microsoft.SQLServer.2016.AlwaysOn.SuspendDataMovement

Aggregate Monitors (3)

DisplayName	ID	Target	Algorithm	Category	Enabled	Alert Generate	Accessibility
可用性组扩展的运行状况状态	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthUserPolicyAggregateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	WorstOf	AvailabilityHealth	True	False	Public
可用性副本扩展的运行状况状态	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaUserPolicyAggregateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	WorstOf	AvailabilityHealth	True	False	Public
数据库副本扩展的运行状况状态	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaUserPolicyAggregateMonitor	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	WorstOf	AvailabilityHealth	True	False	Public

Dependency Monitors (14)

DisplayName	ID	Target	Algorithm	Source Monitor	Relationship	Category	Enabled	Alert Generate	Accessibility
可用性副本连接(汇总)	Microsoft.SQLServer.2016.AlwaysOn.AllAvailabilityReplicasAreConnectedRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.AllAvailabilityReplicasAreConnected	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性组自动故障转移(汇总)	Microsoft.SQLServer.2016.AlwaysOn.AutomaticFailoverReadinessRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.AutomaticFailoverReadiness	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	True	Public
可用性组严重策略(汇总)	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthErrorUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthHostsErrorUserPolicy	AvailabilityHealth	True	False	Public
可用性组警告策略(汇总)	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthWarningUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthHostsWarningUserPolicy	AvailabilityHealth	True	False	Public
可用性组联机(汇总)	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupOnlineRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupOnline	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	True	Public
可用性组扩展的运行状况状态(汇总)	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthUserPolicyAggregateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性副本严重策略(汇总)	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaHostsErrorUserPolicy	AvailabilityHealth	True	False	Public
可用性副本角色(汇总)	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleStateRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False	Public
同步副本数据同步(汇总)	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizationStateRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizationState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性副本数据同步(汇总)	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizingRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizing	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性副本警告策略(汇总)	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaHostsWarningUserPolicy	AvailabilityHealth	True	False	Public
WSFC 群集(汇总)	Microsoft.SQLServer.2016.AlwaysOn.ClusterStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.ClusterStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	True	Public
数据库副本严重策略(汇总)	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaHostsErrorUserPolicy	AvailabilityHealth	True	False	Public
数据库副本警告策略(汇总)	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	WorstOf	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaHostsWarningUserPolicy	AvailabilityHealth	True	False	Public

Unit Monitors (20)

DisplayName	ID	Target	Category	Enabled	Alert Generate	Accessibility
可用性副本连接监视器	Microsoft.SQLServer.2016.AlwaysOn.AllAvailabilityReplicasAreConnected	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性组自动故障转移监视器	Microsoft.SQLServer.2016.AlwaysOn.AutomaticFailoverReadiness	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性组运行状况策略	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorUserPolicy	AvailabilityHealth	True	False	Public
可用性组联机监视器	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupOnline	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性组运行状况策略	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningUserPolicy	AvailabilityHealth	True	False	Public
可用性副本数据同步	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaDataSynchronizationHealth	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	AvailabilityHealth	True	False	Public
可用性副本运行状况策略	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorUserPolicy	AvailabilityHealth	True	False	Public
可用性副本连接	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaIsConnected	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	AvailabilityHealth	True	False	Public
可用性副本联接状态	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaIsJoined	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	AvailabilityHealth	True	False	Public
可用性副本角色监视器	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
同步副本数据同步监视器	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizationState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性副本数据同步监视器	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizing	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性副本运行状况策略	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningUserPolicy	AvailabilityHealth	True	False	Public
WSFC 群集监视器	Microsoft.SQLServer.2016.AlwaysOn.ClusterStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
数据库副本运行状况策略	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorUserPolicy	AvailabilityHealth	True	False	Public
数据库副本运行状况策略	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningUserPolicy	AvailabilityHealth	True	False	Public
可用性数据库数据同步	Microsoft.SQLServer.2016.AlwaysOn.DbrDataSynchronizationState	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	AvailabilityHealth	True	False	Public
可用性数据库联接状态	Microsoft.SQLServer.2016.AlwaysOn.DbrJoinState	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	AvailabilityHealth	True	False	Public
可用性数据库挂起状态	Microsoft.SQLServer.2016.AlwaysOn.DbrSuspendState	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	AvailabilityHealth	True	False	Public
可用性副本角色	Microsoft.SQLServer.2016.AlwaysOn.RoleOfAvailabilityReplicaIsHealthy	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	AvailabilityHealth	True	False	Public

Rules (24)

DisplayName	ID	Target	Category	Enabled	Alert Generate
MSSQL 2016: 可用性副本角色已更改	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleChanged	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	EventCollection	True	True
MSSQL 2016: 从副本接收的字节数/秒	Microsoft.SQLServer.2016.AlwaysOn.BytesReceivedFromReplicaPerSecond	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2016: 发送到副本的字节数/秒	Microsoft.SQLServer.2016.AlwaysOn.BytesSentToReplicaPerSecond	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2016: 发送到传输的字节数/秒	Microsoft.SQLServer.2016.AlwaysOn.BytesSentToTransportPerSecond	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2016: 数据库副本角色已更改	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaRoleChanged	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	EventCollection	True	True
MSSQL 2016: 接收的文件字节数/秒	Microsoft.SQLServer.2016.AlwaysOn.FileBytesReceivedPerSecond	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 流控制/秒	Microsoft.SQLServer.2016.AlwaysOn.FlowControlPerSecond	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2016: 流控制时间(毫秒/秒)	Microsoft.SQLServer.2016.AlwaysOn.FlowControlTimeSeconds	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2016: 日志应用挂起的队列	Microsoft.SQLServer.2016.AlwaysOn.LogApplyPendingQueue	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 日志应用就绪队列	Microsoft.SQLServer.2016.AlwaysOn.LogApplyReadyQueue	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 接收的日志字节数/秒	Microsoft.SQLServer.2016.AlwaysOn.LogBytesReceivedPerSecond	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 待撤消的日志	Microsoft.SQLServer.2016.AlwaysOn.LogRemainingForUndo	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 日志发送队列	Microsoft.SQLServer.2016.AlwaysOn.LogSendQueue	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 已镜像的写入事务数/秒	Microsoft.SQLServer.2016.AlwaysOn.MirroredWriteTransactionsPerSecond	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 从副本接收的字节数/秒	Microsoft.SQLServer.2016.AlwaysOn.ReceivesFromReplicaPerSecond	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2016: 重新发送的消息数/秒	Microsoft.SQLServer.2016.AlwaysOn.RecentMessagesPerSecond	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2016: 恢复队列	Microsoft.SQLServer.2016.AlwaysOn.RecoveryQueue	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 已阻塞的重做/秒	Microsoft.SQLServer.2016.AlwaysOn.RedoBlockedSec	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 剩余的重做字节	Microsoft.SQLServer.2016.AlwaysOn.RedoBytesRemaining	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 重新完成的字节数/秒	Microsoft.SQLServer.2016.AlwaysOn.RedoneBytesPerSecond	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 发送到副本的字节数/秒	Microsoft.SQLServer.2016.AlwaysOn.SendsToReplicaPerSecond	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2016: 发送到传输的字节数/秒	Microsoft.SQLServer.2016.AlwaysOn.SendsToTransportPerSecond	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2016: 需要撤消的日志总数	Microsoft.SQLServer.2016.AlwaysOn.TotalLogRequiringUndo	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2016: 事务延迟时间	Microsoft.SQLServer.2016.AlwaysOn.TransactionDelay	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False

Console Tasks (10)

DisplayName	ID	Target	Accessibility	Enabled
强制故障转移	Microsoft.SQLServer.2016.AlwaysOn.ForcedFailoverForAvailabilityReplica	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	Internal	True
手动故障转移	Microsoft.SQLServer.2016.AlwaysOn.ManualFailoverForAvailabilityReplica	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	Internal	True
恢复数据移动	Microsoft.SQLServer.2016.AlwaysOn.ResumeDataMovement	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	Internal	True
SQL Server PowerShell	Microsoft.SQLServer.2016.AlwaysOn.RunPowerShellForAvailabilityGroup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	Internal	True
SQL Server PowerShell	Microsoft.SQLServer.2016.AlwaysOn.RunPowerShellForAvailabilityReplica	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	Internal	True
SQL Server PowerShell	Microsoft.SQLServer.2016.AlwaysOn.RunPowerShellForDatabaseReplica	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	Internal	True
SQL Server Management Studio	Microsoft.SQLServer.2016.AlwaysOn.RunSSMSForAvailabilityGroup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	Internal	True
SQL Server Management Studio	Microsoft.SQLServer.2016.AlwaysOn.RunSSMSForAvailabilityReplica	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	Internal	True
SQL Server Management Studio	Microsoft.SQLServer.2016.AlwaysOn.RunSSMSForDatabaseReplica	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	Internal	True
挂起数据移动	Microsoft.SQLServer.2016.AlwaysOn.SuspendDataMovement	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	Internal	True