This monitor switches to warning state once Data Warehouse event data collection writer experiences a problem
The Data Warehouse Event Data Collection Writer process encountered an error writing to the Data Warehouse. This monitor will switch to a yellow state if the Event 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 Event 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.
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.EventCollectionWriterState.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.EventCollectionWriterState.FirstChanceState" Accessibility="Internal" Enabled="true" Target="DataWarehouse!Microsoft.SystemCenter.DataWarehouseConnectorServer" ParentMonitorID="Microsoft.SystemCenter.DataWarehouse.ManagementServer.EventCollectionWriterState.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.CollectEventData</WorkflowName>
<FirstEventId>31551</FirstEventId>
<SecondEventId>31554</SecondEventId>
</Configuration>
</UnitMonitor>