Database Options – Auto Close and why should set it to OFF

By | 2020-02-12

Auto close is one of those features that should have been removed long back. The setting needs to stay at default of OFF for reasons that will be made obvious in this video. In this series of videos we cover each of the database options what they do and why they should be set to specific values. Understanding these options opens up a number of different ways for the DBA to tune the database but can also cause issues when implemented incorrectly. With this series we hope to dispel some myths and provide real world example on SQL Server best practices.

Need more information? Visit


To know more about Jayanth Kurup visit


Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years’ experience. He has worked with companies like Microsoft, IBM, HCL, Wipro, Well Fargo, Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community.


In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc


You can also reach Jayanth via his LinkedIn profile below

Category: Databases

About Jayanth Kurup

This post was written by Jayanth Kurup. A Microsoft SQL Server Consultant and Trainer based out of Bangalore, India. Jayanth has been working on MS SQL Server for over 15 years. He is a performance tuning and Business Intelligence expert. Having worked with companies like Microsoft, DELL, Wells Fargo, Thomson Reuters and many other fortune 100 companies. Some other technologies Jayanth works on include Microsoft Azure, PowerBI, Python and AWS. When he isn’t consulting or training, Jayanth like to travel, paint and read. He is also very active in social causes and the founder of Enabled Business Solutions. Visit his company by clicking the link in the menu or email him directly.