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 Hive | HKEY_LOCAL_MACHINE |
Registry Path | SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Data Warehouse\ |
Value Name | Bulk Insert Command Time Out Seconds |
Value Type | REG_DWORD |
Enabled Value | 1 |
Disabled Value | 0 |
Registry Hive | HKEY_LOCAL_MACHINE |
Registry Path | SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Data Warehouse\ |
Value Name | Bulk Insert Command Time Out Seconds |
Value Type | REG_DWORD |
Default Value | |
Min Value | 30 |
Max Value | 90 |