SQL Agent in SQL Server 2012 is flooding SQL Agent Logs every 90 seconds


Hello

In SQL Agent logs for SQL Server 2012 you may see following message that appears every 90 seconds: “Reloading agent settings”. It’s indeed painful behavior from the user perspectives, and we will address this
issue in nearest Service Pack for SQL Server 2012. For now I can suggest you the the following workaround:

Go to registry on your SQL Server machine and navigate to corresponding SQL Instance registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ MSSQL11.YOUR_INSTANCE_NAME\SQLServerAgent

Change registry settings called “AutoRegistryRefresh” from 1 to 0.

The side impact of this: if you change any default settings behavior for SQL Agent, you may need to restart SQL Agent to get it.

Thanks

Alex

Comments (2)

  1. Al Almeida says:

    I would caution you to instead of applying this workaround to try to get the patch from Microsoft, if you read this connect ( connect.microsoft.com/…/729700 ) post you will see that changing the registry value has caused some SQL Servers to crash. You can find me at: http://www.artdigitalonline.com/blog

  2. james says:

    Thank you sharing your knowledge. it worked with me