Home
  •  

Data Warehouse Object Health State Data Collection Writer Periodic Data Maintenance Recovery State

Microsoft.SystemCenter.DataWarehouse.ManagementServer.StateDataMaintenanceState.WriterMaintenance.RecoveryState (UnitMonitor)

This monitor switches to a warning state once Data Warehouse object health state data collection writer periodic data maintenance process experiences a problem and does not recover from that problem in a configured amount of time

Knowledge Base article:

Summary

The Data Warehouse Object Health State Data Collection Writer Periodic Data Maintenance process encountered a persistent error writing to the Data Warehouse. This monitor will alert if the Data Warehouse Object Health State Data Collection Writer Periodic Data Maintenance process running on a Management Server encounters a persistent error writing to the Data Warehouse. If the writer process has not successfully completed within a 5 minute interval (by default), this 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.StateDataWriterMaintenanceState.Rollup
CategoryStateCollection
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SystemCenter.DataWarehouse.2SingleEventLogTimed2StateUnitMonitorType
RemotableTrue
AccessibilityInternal
Alert Message
Data Warehouse object health state data writer process failed to perform maintenance operation
Data Warehouse object health state data writer process failed to perform maintenance operation. {0}
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SystemCenter.DataWarehouse.ManagementServer.StateDataMaintenanceState.WriterMaintenance.RecoveryState" Accessibility="Internal" Enabled="true" Target="DataWarehouse!Microsoft.SystemCenter.DataWarehouseConnectorServer" ParentMonitorID="Microsoft.SystemCenter.DataWarehouse.ManagementServer.StateDataWriterMaintenanceState.Rollup" TypeID="DataWarehouse!Microsoft.SystemCenter.DataWarehouse.2SingleEventLogTimed2StateUnitMonitorType" ConfirmDelivery="true">

  <Category>StateCollection</Category>

  <AlertSettings AlertMessage="Microsoft.SystemCenter.DataWarehouse.ManagementServer.StateDataMaintenanceState.WriterMaintenance.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/Item0Context/DataItem/EventDescription$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

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

    <OperationalState ID="Bad" MonitorTypeStateID="FirstEventRaisedAndNoSecondEventRaisedInTimeInterval" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

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

    <FirstEventId>31553</FirstEventId>

    <SecondEventId>31572</SecondEventId>

    <TimeIntervalSeconds>300</TimeIntervalSeconds>

  </Configuration>

</UnitMonitor>