SCOM 2012 – SQL Reconnect interval

So I found out the reason why I kept getting the SQL reconnect issue with Ops Manager 2012 that I was having here – Powershell Script to restart SCOM. It turns out that by default Ops Manager 2012 does not automatically try to reconnect to its SQL server. I believe the default interval is like 60 seconds so you will probably want to change that registry key as well. Below is the fix for enabling the SQL reconnect interval.

To enable the automatic recovery feature on the management server, follow these steps:

  1. Start Registry Editor.
  2. Locate and then click the following registry subkey:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\System Center\2010\Common\DAL
  3. Create the following two registry entries:
    • DALInitiateClearPoolType: DWORD
      Decimal value: 1
    • DALInitiateClearPoolSecondsType: DWORD
      Decimal Value: 60Note 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.
  4. Restart the System Center Management service on the management server.

Best of luck!

Advertisements

~ by Josh on February 25, 2014.

2 Responses to “SCOM 2012 – SQL Reconnect interval”

  1. Still needed in 2012 R2?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: