Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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.
1 2 3 4 | USE [master] GO ALTER DATABASE [deneme] SET AUTO_CLOSE OFF; GO |
Or right-click on the database and go to the Options tab. Then set it to False as follows.
