Data Access Layer reconnection to SQL Server

This setting enable the automatic recovery feature in System Center 2012 Operations Manager. By default, this automatic recovery feature is disabled. All management servers in a management group should get the registry change.
The DALInitiateClearPoolSeconds setting controls when the management server drops the current connection pool and when the management server tries to reestablish an SQL connection. We recommend that you set this setting to 60 seconds or more to avoid performance issues. http://support.microsoft.com/kb/2913046/en-us

This policy create REG_DWORD Decimal Values: "DALInitiateClearPool" and "DALInitiateClearPoolSeconds" in registry key: "HKLM\SOFTWARE\Microsoft\System Center\2010\Common\DAL\" .
SCOM 2012 existing registry value: not present (must create value).
To delete REG_DWORD value from registry, disable this policy.

Minimum value (in this group policy template) = 5 seconds
Maximum value (in this group policy template) = 300 seconds (5 minutes)
Recomended value for large environments: 60 seconds (1 minute)

Supported on: System Center 2012 Operations Manager

Registry HiveHKEY_LOCAL_MACHINE
Registry PathSOFTWARE\Microsoft\System Center\2010\Common\DAL\
Value NameDALInitiateClearPool
Value TypeREG_DWORD
Enabled Value1
Disabled Value0



Registry HiveHKEY_LOCAL_MACHINE
Registry PathSOFTWARE\Microsoft\System Center\2010\Common\DAL\
Value NameDALInitiateClearPoolSeconds
Value TypeREG_DWORD
Default Value30
Min Value15
Max Value300

opsmgrservertweaking.admx