Home
  •  

Worker Database Response Time

Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Monitor.WorkerDatabaseResponseTime (UnitMonitor)

監視效能計數器 Worker Database Response Time。

Knowledge Base article:

摘要

監視對 Service Management Automation 資料庫提出之要求的回應時間。

原因

資料庫回應時間太低。可能是因為資料庫已超載。

解決方式

如果此問題持續發生，請減少 Worker 數目，以減輕資料庫負載並解決問題。

設定

您可以在此監視上設定下列選項:

選項

定義

預設值

警示開啟狀態

產生警示之監視的健全狀況狀態。

監視處於重大的健全狀況狀態

警示優先順序

此監視所產生之警示的優先順序。

中

警示嚴重性

此監視所產生之警示的優先順序。

重大

自動解決警示

指定當監視恢復狀況良好狀態時，是否應自動解除警示。

True

CounterName

效能計數器的名稱。除了由語言套件覆寫外，不應覆寫此值。

WorkerDatabaseResponseTime

已啟用

指定監視是否應執行。

True

產生警示

指定當變更為警告或重大狀態時，監視是否應產生警示。

True

Element properties:

TargetMicrosoft.SystemCenter.ServiceManagementAutomation.2012R2.Server.Worker
Parent MonitorSystem.Health.PerformanceState
CategoryPerformanceHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityMatchMonitorHealth
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SystemCenter.ServiceManagementAutomation.2012R2.Performance.MonitorType.ConsecutiveSamplesThreshold
RemotableTrue
AccessibilityPublic
Alert Message
Worker Database Response Time
Worker Database Response Time 已超過閾值。上次測量的值是 {0}。
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Monitor.WorkerDatabaseResponseTime" Accessibility="Public" Enabled="true" Target="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Server.Worker" ParentMonitorID="Health!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Performance.MonitorType.ConsecutiveSamplesThreshold" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Monitor.WorkerDatabaseResponseTime.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/Value$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="ConditionTrue" MonitorTypeStateID="ConditionTrue" HealthState="Error"/>

    <OperationalState ID="ConditionFalse" MonitorTypeStateID="ConditionFalse" HealthState="Success"/>

  </OperationalStates>

  <Configuration>

    <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

    <CounterName>Worker Database Response Time</CounterName>

    <ObjectName>Orchestrator Worker Performance Counters</ObjectName>

    <InstanceName/>

    <AllInstances>true</AllInstances>

    <Frequency>600</Frequency>

    <ScaleBy>1</ScaleBy>

    <Threshold>2</Threshold>

    <Direction>greater</Direction>

    <NumSamples>3</NumSamples>

  </Configuration>

</UnitMonitor>