Bulk Insert Command Time Out Seconds

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

Supported on: System Center 2012 Operations Manager

Registry HiveHKEY_LOCAL_MACHINE
Registry PathSOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Data Warehouse\
Value NameBulk Insert Command Time Out Seconds
Value TypeREG_DWORD
Enabled Value1
Disabled Value0



Registry HiveHKEY_LOCAL_MACHINE
Registry PathSOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Data Warehouse\
Value NameBulk Insert Command Time Out Seconds
Value TypeREG_DWORD
Default Value
Min Value30
Max Value90

opsmgrservertweaking.admx