This monitor switches to a warning state once Data Warehouse object health state data collection writer periodic data maintenance process experiences a problem
The Data Warehouse Object Health State Data Collection Writer Periodic Data Maintenance process encountered an error writing to the Data Warehouse. This monitor will switch to a yellow state if the Data Warehouse Object Health State Data Collection Writer Periodic Data Maintenance 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 Health State Data Collection Writer Periodic Data Maintenance Recovery monitor starts a timer. If the writer process has not successfully completed within a 5 minute interval (by default), that monitor will alert. Note that the interval is overrideable.
This is most commonly caused by connectivity issues to the SQL Server hosting the Data Warehouse, or that SQL Server performance is slow.
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.
Target | Microsoft.SystemCenter.DataWarehouseConnectorServer |
Parent Monitor | Microsoft.SystemCenter.DataWarehouse.ManagementServer.StateDataWriterMaintenanceState.Rollup |
Category | StateCollection |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Monitor Type | Microsoft.SystemCenter.DataWarehouse.2SingleEventLog2StateUnitMonitorType |
Remotable | True |
Accessibility | Internal |
RunAs | Default |
<UnitMonitor ID="Microsoft.SystemCenter.DataWarehouse.ManagementServer.StateDataMaintenanceState.WriterMaintenance.FirstChanceState" Accessibility="Internal" Enabled="true" Target="DataWarehouse!Microsoft.SystemCenter.DataWarehouseConnectorServer" ParentMonitorID="Microsoft.SystemCenter.DataWarehouse.ManagementServer.StateDataWriterMaintenanceState.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>31553</FirstEventId>
<SecondEventId>31572</SecondEventId>
</Configuration>
</UnitMonitor>