Microsoft SQL Server 2012 AlwaysOn 监视管理包语言包

Microsoft.SQLServer.2012.AlwaysOn.Monitoring :: 6.6.3.0 (Management Pack)

AlwaysOn 运行状况监视管理包

摘要

此管理包包含用于收集和显示 AlwaysOn 对象的运行状况的监视器、规则、警报和其他类。

Management Pack Elements

Show Management Pack References

TypeDefinitions

UnitMonitorType (2)
SecureReference (1)

Categories

Category (10)

Monitoring

Monitors

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

Rule (20)

Presentation

ConsoleTask (10)
FolderItem (2)
View (2)

Unit Monitor Types (2)

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

Secure References (1)

	DisplayName	ID	Context	Accessibility
	AlwaysOn 监视帐户	Microsoft.SQLServer.2012.AlwaysOn.MonitoringAccount	System.Entity	Public

Categories (10)

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

Aggregate Monitors (3)

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

Dependency Monitors (14)

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

Unit Monitors (20)

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

Rules (20)

DisplayName	ID	Target	Category	Enabled	Alert Generate
Bytes Received from Replica/sec	Microsoft.SQLServer.2012.AlwaysOn.BytesReceivedFromReplicaPerSecond	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
Bytes Sent to Replica/sec	Microsoft.SQLServer.2012.AlwaysOn.BytesSentToReplicaPerSecond	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
Bytes Sent to Transport/sec	Microsoft.SQLServer.2012.AlwaysOn.BytesSentToTransportPerSecond	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
File Bytes Received/sec	Microsoft.SQLServer.2012.AlwaysOn.FileBytesReceivedPerSecond	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
Flow Control/sec	Microsoft.SQLServer.2012.AlwaysOn.FlowControlPerSecond	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
流控制时间	Microsoft.SQLServer.2012.AlwaysOn.FlowControlTimeSeconds	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
Log Bytes Received/sec	Microsoft.SQLServer.2012.AlwaysOn.LogBytesReceivedPerSecond	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
待撤消的日志	Microsoft.SQLServer.2012.AlwaysOn.LogRemainingForUndo	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
日志发送队列	Microsoft.SQLServer.2012.AlwaysOn.LogSendQueue	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
Mirrored Write Transactions/sec	Microsoft.SQLServer.2012.AlwaysOn.MirroredWriteTransactionsPerSecond	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
Receives from Replica/sec	Microsoft.SQLServer.2012.AlwaysOn.ReceivesFromReplicaPerSecond	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
Resent Messages/sec	Microsoft.SQLServer.2012.AlwaysOn.RecentMessagesPerSecond	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
恢复队列	Microsoft.SQLServer.2012.AlwaysOn.RecoveryQueue	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
已阻塞的重做/秒	Microsoft.SQLServer.2012.AlwaysOn.RedoBlockedSec	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
剩余的重做字节	Microsoft.SQLServer.2012.AlwaysOn.RedoBytesRemaining	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
Redone Bytes/sec	Microsoft.SQLServer.2012.AlwaysOn.RedoneBytesPerSecond	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
Sends to Replica/sec	Microsoft.SQLServer.2012.AlwaysOn.SendsToReplicaPerSecond	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
Sends to Transport/sec	Microsoft.SQLServer.2012.AlwaysOn.SendsToTransportPerSecond	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
需要撤消的日志总数	Microsoft.SQLServer.2012.AlwaysOn.TotalLogRequiringUndo	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
事务延迟时间	Microsoft.SQLServer.2012.AlwaysOn.TransactionDelay	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False

Console Tasks (10)

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

Folder Items (2)

	DisplayName	ID	FolderName	ElementID
	可用性副本性能	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceView	Microsoft.SQLServer.2012.AlwaysOn.PerformanceFolder	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceView
	数据库副本性能	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceView	Microsoft.SQLServer.2012.AlwaysOn.PerformanceFolder	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceView

Views (2)

	DisplayName	ID	Target	Type	Accessibility	Visible
	可用性副本性能	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaPerformanceView	Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplica	Microsoft.SystemCenter.PerformanceViewType	Internal	True
	数据库副本性能	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplicaPerformanceView	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	Microsoft.SystemCenter.PerformanceViewType	Internal	True