Home
  •  

Data Warehouse Object Health State Data Collection Writer First Chance State

Microsoft.SystemCenter.DataWarehouse.ManagementServer.StateCollectionWriterState.FirstChanceState (UnitMonitor)

This monitor switches to warning state once Data Warehouse object health state data collection writer experiences a problem

Knowledge Base article:

Summary

The Data Warehouse Object Health State Data Collection Writer process encountered an error writing to the Data Warehouse. This monitor will switch to a yellow state if the Object Health State Data Collection Writer process running on a Management Server encounters an error writing to the Data Warehouse. By default, the monitor will not raise an alert, since the write errors may be transient. Once this monitor turns yellow, the Data Warehouse Object State Data Collection Writer Recovery monitor starts a timer. If the writer process has not successfully completed within a 2 minute interval (by default), that monitor will alert. Note that the interval is overrideable.

Causes

This is most commonly caused by connectivity issues to the SQL Server hosting the Data Warehouse, or that SQL Server performance is slow.

Resolutions

Ensure that there is connectivity from the Management Server to the SQL Server hosting the Data Warehouse. Communication could be blocked by a firewall for example. Ensure that the Data Warehouse Action Account is able to connect to the Data Warehouse database. If you are experiencing time-out issues, examine the utilization of the SQL server to determine if it’s being overloaded. Important counters to look at are: CPU utilization, memory utilization and Disk I/O.

Element properties:

TargetMicrosoft.SystemCenter.DataWarehouseConnectorServer
Parent MonitorMicrosoft.SystemCenter.DataWarehouse.ManagementServer.StateCollectionWriterState.Rollup
CategoryStateCollection
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SystemCenter.DataWarehouse.2SingleEventLog2StateUnitMonitorType
RemotableTrue
AccessibilityInternal
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SystemCenter.DataWarehouse.ManagementServer.StateCollectionWriterState.FirstChanceState" Accessibility="Internal" Enabled="true" Target="DataWarehouse!Microsoft.SystemCenter.DataWarehouseConnectorServer" ParentMonitorID="Microsoft.SystemCenter.DataWarehouse.ManagementServer.StateCollectionWriterState.Rollup" TypeID="DataWarehouse!Microsoft.SystemCenter.DataWarehouse.2SingleEventLog2StateUnitMonitorType" ConfirmDelivery="true">

  <Category>StateCollection</Category>

  <OperationalStates>

    <OperationalState ID="Bad" MonitorTypeStateID="FirstEventRaised" HealthState="Warning"/>

    <OperationalState ID="Good" MonitorTypeStateID="SecondEventRaised" HealthState="Success"/>

  </OperationalStates>

  <Configuration>

    <WorkflowName>Microsoft.SystemCenter.DataWarehouse.CollectEntityHealthStateChange</WorkflowName>

    <FirstEventId>31551</FirstEventId>

    <SecondEventId>31554</SecondEventId>

  </Configuration>

</UnitMonitor>