Home
  •  

Worker Database Exceptions Per Second

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

Monitors performance counter Worker Database Exceptions Per Second.

Knowledge Base article:

Summary

Monitors the number of database exceptions occurring per second.

Causes

If the monitor is in an error state, the database is currently overloaded. This condition can be caused by a variety of reasons.

Resolution

Some reasons could be temporary, and the database can return to normal state in time.

Configuration

The following options can be configured on this monitor:

Option

Definition

Default

Alert On State

Health state for the monitor that generates an alert.

The monitor is in a critical health state

Alert Priority

Priority of the alert generated for this monitor.

Medium

Alert Severity

Priority of the alert generated for this monitor.

Critical

Auto-Resolve Alert

Specifies whether the alert should automatically be resolved when the monitor returns to a healthy state.

True

CounterName

Name of the performance counter. This value should not be overridden except by a language pack.

WorkerDatabaseExceptionsPerSec

Enabled

Specifies whether the monitor should run.

True

Generates Alert

Specifies whether the monitor should generate an alert when changing to a warning or critical state.

True

Element properties:

TargetMicrosoft.SystemCenter.ServiceManagementAutomation.2012R2.Server.Worker
Parent MonitorSystem.Health.PerformanceState
CategoryPerformanceHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SystemCenter.ServiceManagementAutomation.2012R2.Performance.MonitorType.ConsecutiveSamplesThreshold
RemotableTrue
AccessibilityPublic
Alert Message
Worker Database Exceptions Per Second
Worker Database Exceptions Per Second has exceeded threshold. Last measured value is {0}.
RunAsDefault

Source Code:

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

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</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 Exceptions Per Sec</CounterName>

    <ObjectName>Orchestrator Worker Performance Counters</ObjectName>

    <InstanceName/>

    <AllInstances>true</AllInstances>

    <Frequency>600</Frequency>

    <ScaleBy>1</ScaleBy>

    <Threshold>0</Threshold>

    <Direction>greater</Direction>

    <NumSamples>3</NumSamples>

  </Configuration>

</UnitMonitor>