监视性能计数器 Worker Database Requests Per Second。
监视每秒钟向 Service Management Automation 数据库提出的请求数。
Web 角色以及 Worker 角色都向数据库提出请求。高数据库请求率表示流量过大,并且可能导致性能下降。
减少工作负荷或 Worker 数可能会降低数据库命中率并解决此问题。
可以在此监视器上配置以下选项:
选项 | 定义 | 默认值 |
警报所处状态 | 生成警报的监视器的健康状况。 | 监视器处于严重健康状况 |
警报优先级 | 针对此监视器生成的警报的优先级。 | 中 |
警报严重性 | 针对此监视器生成的警报的优先级。 | 严重 |
自动解决警报 | 指定当监视器恢复正常状态时是否应该自动解决警报。 | 真 |
CounterName | 性能计数器的名称。不应该覆盖此值,除非由语言包进行覆盖。 | WorkerDatabaseRequestsPerSec |
已启用 | 指定是否应该运行监视器。 | 真 |
生成警报 | 指定当更改为警告或严重状态时监视器是否应该生成警报。 | 真 |
Target | Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Server.Worker | ||
Parent Monitor | System.Health.PerformanceState | ||
Category | PerformanceHealth | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | MatchMonitorHealth | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.Performance.MonitorType.ConsecutiveSamplesThreshold | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<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>