A scenario might occur where a SQL outage exists, and then the management servers will not automatically connect to SQL again once it comes back up on the network. If you have experienced this you should consider applying this resolution.
However – those registry locations have changed in OM 2012. This was done to sync the Data Access layer between Service Manager and SCOM. There has been some confusion if these configuration settings are supported and/or work in SCOM 2012.
The new locations are documented at: http://support.microsoft.com/kb/2913046/en-us
Start the Registry Editor.
Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\System Center\2010\Common\DAL
Create the following two new DWORD values:
- DALInitiateClearPool
Type: DWORD
Decimal value: 1- DALInitiateClearPoolSeconds
Type: DWORD
Decimal Value: 60
DALInitiateClearPool should be set to Decimal value “1” to enable it.
DALInitiateClearPoolSeconds should be set to Decimal value “60” to represent 60 second retry interval. 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.
Restart the System Center Data Access Service, and the System Center Management/Microsoft Monitoring Agent service on the management server for these settings to take effect.
