Microsoft Systems Center Operations Manager (SCOM) is running on Microsoft Windows 2008 and has Service Pack 1 (SP1) installed on it.
Here is the description of the alert being generated in the SCOM operator console:
Alert description: Data Warehouse managed object type synchronization process failed to write data to the Data Warehouse database. Failed to store data in the Data Warehouse. The operation will be retried. Exception ‘SqlException’: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding
Also lot of event IDs 2115 with source HealthService appear in the event viewer on the SCOM server.
A 2115 event is generated when a single batch data insertion to the OperationsManager database or OperationsManagerDW takes longer than one minute.
This can occur if the management server receives a burst of data items from agents or other management servers. To resolve the issue, follow these steps:
Launch the SCOM Console , switch to Authoring space , and click Rules .
In the right top hand side of the screen, click Change Scope .
Select Data Warehouse Connection Server in the list of types, and click OK .
Find the Event data collector rule in the list of rules.
Right-click the Event data collector rule, select Overrides/Override the Rule/For all objects of type… .
Set Max Execution Attempt Count to 10 .
Set Execution Attempt Timeout Interval Seconds to 6 .
Reset/recalculate the health.
This fixed the issue.