Microsoft SQL Server on Windows Azure Virtual Machines

The writers of this blog are a part of the Microsoft SQL Server team. We will be blogging about our tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Server components on Windows Azure Virtual machines

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

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

  • Comments 2

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

Leave a Comment
  • Please add 6 and 3 and type the answer here:
  • Post
  • 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: www.artdigitalonline.com/blog

  • Thank you sharing your knowledge. it worked with me

Page 1 of 1 (2 items)