Microsoft SQL Server 2014 Always On (Monitoring) 語言套件

Microsoft.SQLServer.2014.AlwaysOn.Monitoring :: 6.7.7.0 (Management Pack)

此管理組件會啟用 Microsoft SQL Server 2014 Always On 功能的監視。它與 Microsoft SQL 2014 Always On (Discovery) 管理組件相依。

Management Pack Elements

Show Management Pack References

TypeDefinitions

UnitMonitorType (2)
SecureReference (1)

Categories

Category (10)

Monitoring

Monitors

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

Rule (22)

Presentation

ConsoleTask (10)

Unit Monitor Types (2)

	DisplayName	ID	Accessibility	Support Monitor Recalculate
	MSSQL 2014: Two State System Policy 監視器類型	Microsoft.SQLServer.2014.AlwaysOn.SystemPolicyScriptMonitorType	Internal	False
	MSSQL 2014: Two State User Policy 監視器類型	Microsoft.SQLServer.2014.AlwaysOn.UserPolicyScriptMonitorType	Internal	False

Secure References (1)

	DisplayName	ID	Context	Accessibility
	Microsoft SQL Server 2014 Always On Monitoring 執行身分設定檔	Microsoft.SQLServer.2014.AlwaysOn.MonitoringAccount	System.Entity	Public

Categories (10)

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

Aggregate Monitors (3)

DisplayName	ID	Target	Algorithm	Category	Enabled	Alert Generate	Accessibility
可用性群組擴充健全狀態	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthUserPolicyAggregateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	WorstOf	AvailabilityHealth	True	False	Public
可用性複本擴充健全狀態	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaUserPolicyAggregateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	WorstOf	AvailabilityHealth	True	False	Public
資料庫複本擴充健全狀態	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaUserPolicyAggregateMonitor	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	WorstOf	AvailabilityHealth	True	False	Public

Dependency Monitors (14)

DisplayName	ID	Target	Algorithm	Source Monitor	Relationship	Category	Enabled	Alert Generate	Accessibility
可用性複本連接 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.AllAvailabilityReplicasAreConnectedRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.AllAvailabilityReplicasAreConnected	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性群組自動容錯移轉 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.AutomaticFailoverReadinessRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.AutomaticFailoverReadiness	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	True	Public
可用性群組重大原則 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthErrorUserPolicyStateMonitorRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsErrorUserPolicy	AvailabilityHealth	True	False	Public
可用性群組警告原則 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthWarningUserPolicyStateMonitorRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsWarningUserPolicy	AvailabilityHealth	True	False	Public
可用性群組線上 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupOnlineRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupOnline	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	True	Public
可用性群組擴充健全狀態 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupUserPolicyStateMonitorRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthUserPolicyAggregateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性複本重大原則 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicyStateMonitorRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaHostsErrorUserPolicy	AvailabilityHealth	True	False	Public
可用性複本角色 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleStateRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleState	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False	Public
同步複本資料同步處理 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizationStateRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizationState	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性複本資料同步處理 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizingRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizing	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性複本警告原則 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicyStateMonitorRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaHostsWarningUserPolicy	AvailabilityHealth	True	False	Public
WSFC 叢集 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.ClusterStateMonitorRollup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.ClusterStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	True	Public
資料庫複本重大原則 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicyStateMonitorRollup	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaHostsErrorUserPolicy	AvailabilityHealth	True	False	Public
資料庫複本警告原則 (彙總)	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicyStateMonitorRollup	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	WorstOf	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaHostsWarningUserPolicy	AvailabilityHealth	True	False	Public

Unit Monitors (20)

DisplayName	ID	Target	Category	Enabled	Alert Generate	Accessibility
可用性複本連接監視器	Microsoft.SQLServer.2014.AlwaysOn.AllAvailabilityReplicasAreConnected	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性群組自動容錯移轉監視器	Microsoft.SQLServer.2014.AlwaysOn.AutomaticFailoverReadiness	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性群組健全狀況原則	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorUserPolicy	AvailabilityHealth	True	False	Public
可用性群組線上監視器	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupOnline	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性群組健全狀況原則	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningUserPolicy	AvailabilityHealth	True	False	Public
可用性複本資料同步處理	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaDataSynchronizationHealth	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	AvailabilityHealth	True	False	Public
可用性複本健全狀況原則	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicy	AvailabilityHealth	True	False	Public
可用性複本連接	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaIsConnected	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	AvailabilityHealth	True	False	Public
可用性複本聯結狀態	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaIsJoined	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	AvailabilityHealth	True	False	Public
可用性複本角色監視器	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleState	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
同步複本資料同步處理監視器	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizationState	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性複本資料同步處理監視器	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicasSynchronizing	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
可用性複本健全狀況原則	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicy	AvailabilityHealth	True	False	Public
WSFC 叢集監視器	Microsoft.SQLServer.2014.AlwaysOn.ClusterStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	AvailabilityHealth	True	False	Public
資料庫複本健全狀況原則	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicy	AvailabilityHealth	True	False	Public
資料庫複本健全狀況原則	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitor	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicy	AvailabilityHealth	True	False	Public
可用性資料庫資料同步處理	Microsoft.SQLServer.2014.AlwaysOn.DbrDataSynchronizationState	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	AvailabilityHealth	True	False	Public
可用性資料庫聯結狀態	Microsoft.SQLServer.2014.AlwaysOn.DbrJoinState	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	AvailabilityHealth	True	False	Public
可用性資料庫暫停狀態	Microsoft.SQLServer.2014.AlwaysOn.DbrSuspendState	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	AvailabilityHealth	True	False	Public
可用性複本角色	Microsoft.SQLServer.2014.AlwaysOn.RoleOfAvailabilityReplicaIsHealthy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	AvailabilityHealth	True	False	Public

Rules (22)

DisplayName	ID	Target	Category	Enabled	Alert Generate
MSSQL 2014: 可用性複本角色已變更	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaRoleChanged	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	EventCollection	True	True
MSSQL 2014: Bytes Received from Replica/sec	Microsoft.SQLServer.2014.AlwaysOn.BytesReceivedFromReplicaPerSecond	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2014: Bytes Sent to Replica/sec	Microsoft.SQLServer.2014.AlwaysOn.BytesSentToReplicaPerSecond	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2014: Bytes Sent to Transport/sec	Microsoft.SQLServer.2014.AlwaysOn.BytesSentToTransportPerSecond	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2014: 資料庫複本角色已變更	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaRoleChanged	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	EventCollection	True	True
MSSQL 2014: File Bytes Received/sec	Microsoft.SQLServer.2014.AlwaysOn.FileBytesReceivedPerSecond	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2014: Flow Control/sec	Microsoft.SQLServer.2014.AlwaysOn.FlowControlPerSecond	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2014: Flow Control Time (ms/sec)	Microsoft.SQLServer.2014.AlwaysOn.FlowControlTimeSeconds	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2014: Log Bytes Received/sec	Microsoft.SQLServer.2014.AlwaysOn.LogBytesReceivedPerSecond	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2014: 進行復原的剩餘記錄	Microsoft.SQLServer.2014.AlwaysOn.LogRemainingForUndo	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2014: 記錄傳送佇列	Microsoft.SQLServer.2014.AlwaysOn.LogSendQueue	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2014: Mirrored Write Transactions/sec	Microsoft.SQLServer.2014.AlwaysOn.MirroredWriteTransactionsPerSecond	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2014: Receives from Replica/sec	Microsoft.SQLServer.2014.AlwaysOn.ReceivesFromReplicaPerSecond	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2014: Resent Messages/sec	Microsoft.SQLServer.2014.AlwaysOn.RecentMessagesPerSecond	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2014: 復原佇列	Microsoft.SQLServer.2014.AlwaysOn.RecoveryQueue	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2014: Redo blocked/sec	Microsoft.SQLServer.2014.AlwaysOn.RedoBlockedSec	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2014: Redo Bytes Remaining	Microsoft.SQLServer.2014.AlwaysOn.RedoBytesRemaining	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2014: Redone Bytes/sec	Microsoft.SQLServer.2014.AlwaysOn.RedoneBytesPerSecond	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2014:Sends to Replica/sec	Microsoft.SQLServer.2014.AlwaysOn.SendsToReplicaPerSecond	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2014: Sends to Transport/sec	Microsoft.SQLServer.2014.AlwaysOn.SendsToTransportPerSecond	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	PerformanceCollection	True	False
MSSQL 2014: 需要復原的總記錄	Microsoft.SQLServer.2014.AlwaysOn.TotalLogRequiringUndo	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False
MSSQL 2014: 交易延遲	Microsoft.SQLServer.2014.AlwaysOn.TransactionDelay	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	PerformanceCollection	True	False

Console Tasks (10)

DisplayName	ID	Target	Accessibility	Enabled
強制容錯移轉	Microsoft.SQLServer.2014.AlwaysOn.ForcedFailoverForAvailabilityReplica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Internal	True
手動容錯移轉	Microsoft.SQLServer.2014.AlwaysOn.ManualFailoverForAvailabilityReplica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Internal	True
繼續進行資料移動	Microsoft.SQLServer.2014.AlwaysOn.ResumeDataMovement	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	Internal	True
SQL Server PowerShell	Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityGroup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	Internal	True
SQL Server PowerShell	Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForAvailabilityReplica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Internal	True
SQL Server PowerShell	Microsoft.SQLServer.2014.AlwaysOn.RunPowerShellForDatabaseReplica	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	Internal	True
SQL Server Management Studio	Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityGroup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	Internal	True
SQL Server Management Studio	Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForAvailabilityReplica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Internal	True
SQL Server Management Studio	Microsoft.SQLServer.2014.AlwaysOn.RunSSMSForDatabaseReplica	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	Internal	True
暫停進行資料移動	Microsoft.SQLServer.2014.AlwaysOn.SuspendDataMovement	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	Internal	True