Setting the Database AUTO_CLOSE Option to OFF to Improve Performance

 

Auto_Close is an option of the database. If set to ON, the database is opened and closed each connection. The procedure cache is cleared every time in this process. If the database is a heavily used database, this causes a serious performance problem.

You can set Auto_Close option to OFF in your database with the help of the following script.

Or right-click on the database and go to the Options tab. Then set it to False as follows.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *