Microsoft SQL Server 2012 AlwaysOn 監視管理組件語言套件

Microsoft.SQLServer.2012.AlwaysOn.Monitoring :: 6.6.4.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
Flow Control Time	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
Log Remaining for undo	Microsoft.SQLServer.2012.AlwaysOn.LogRemainingForUndo	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
Log Send Queue	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
Recovery Queue	Microsoft.SQLServer.2012.AlwaysOn.RecoveryQueue	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
Redo blocked/sec	Microsoft.SQLServer.2012.AlwaysOn.RedoBlockedSec	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
Redo Bytes Remaining	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
Total Log requiring undo	Microsoft.SQLServer.2012.AlwaysOn.TotalLogRequiringUndo	Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
Transaction Delay	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