Pages

Thursday, October 31, 2013

Auto Close and why you want it OFF

So I was perusing my SQL Server Error Logs on my web server and found all my databases restarting. 

All night. 

Every 2 seconds.  

It turns out that the reason for this is that the database is set to automatically shut down whenever there are no more connections.  In a web environment, that means every single time there is a page hit.

We need to turn this off.  Now.

Open SQL Server Management Studio and log in.
From the Object Explorer select

  • Server
    • Databases
      • DatabaseName → Properties


Make sure Auto Close is set to False.


...

Bryan Valencia is a contributing editor and founder of Visual Studio Journey.  He owns and operates Software Services, a web design and hosting company in Manteca, California.

Share This!

Contact Us

Name

Email *

Message *