![SQL SERVER - Set AUTO_CLOSE Database Option to OFF for Better Performance - SQL Authority with Pinal Dave SQL SERVER - Set AUTO_CLOSE Database Option to OFF for Better Performance - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2016/09/autoclose-800x351.png)
SQL SERVER - Set AUTO_CLOSE Database Option to OFF for Better Performance - SQL Authority with Pinal Dave
AppInsight for SQL: Auto Close option for database breaks polling of performance counters and database collation
Report Server Temporary database configuration with Always on Availability groups in SQL server - Microsoft Community Hub
Disable Auto Shrink to avoid performance degradation - OpenUtilities Wiki - OpenUtilities - Bentley Communities
![SQL SERVER - Error - Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group - SQL Authority with Pinal Dave SQL SERVER - Error - Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2017/11/ao-wiz-err-1.jpg)