Data warehouse BULK INSERT commands use an unchangeable, default 30-second time-out value that may cause query time-outs.
The fix for the data warehouse BULK insert commands time out issue that is described in Update Rollup 1 for System Center 2012 R2 Operations Manager (or System Center 2012 Operations Manager SP1 Update Rollup 5) adds a registry key. This key can be used to set the time-out value (in seconds) for the data warehouse BULK insert commands. For example, for a 40-second time-out, set this value to 40.
Recommend changing only to resolve a problem with bulk inserts to the warehouse, which is a RARE condition!
This policy create registry key: "HKLM\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Data Warehouse\" and REG_DWORD Decimal Value: "Bulk Insert Command Time Out Seconds".
SCOM 2012 existing registry value: not preset (must create "Data Warehouse" key and value).
To delete REG_DWORD value from registry, disable this policy.
Default in code value = 30 seconds.
Minimum value (in this group policy template) = 30
Maximum value (in this group policy template) = 90 seconds
|Registry Path||SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Data Warehouse\|
|Value Name||Bulk Insert Command Time Out Seconds|