Home
  •  

Worker Database Requests Per Second

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

監視效能計數器 Worker Database Requests Per Second。

Knowledge Base article:

摘要

監視每秒對 Service Management Automation 資料庫提出的要求。

原因

Web 角色和 Worker 角色都會對資料庫提出要求。較高的資料庫要求率表示流量極高，可能導致效能降低。

解決方式

減少工作負載或 Worker 的數目即可降低資料庫叫用率並解決問題。

設定

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

選項

定義

預設值

警示開啟狀態

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

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

警示優先順序

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

中

警示嚴重性

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

重大

自動解決警示

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

True

CounterName

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

WorkerDatabaseRequestsPerSec

已啟用

指定監視是否應執行。

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 Requests Per Second
Worker Database Requests Per Second 已超過閾值。上次測量的值是 {0}。
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Monitor.WorkerDatabaseRequestsPerSec" 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.WorkerDatabaseRequestsPerSec.AlertMessage">

    <AlertOnState>Warning</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="Warning"/>

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

  </OperationalStates>

  <Configuration>

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

    <CounterName>Worker Database Requests Per Sec</CounterName>

    <ObjectName>Orchestrator Worker Performance Counters</ObjectName>

    <InstanceName/>

    <AllInstances>true</AllInstances>

    <Frequency>600</Frequency>

    <ScaleBy>1</ScaleBy>

    <Threshold>300</Threshold>

    <Direction>greater</Direction>

    <NumSamples>3</NumSamples>

  </Configuration>

</UnitMonitor>