Monday, September 26, 2016

SQL SERVER – Improve performance by turning off AUTO_CLOSE Database Option

Set AUTO_CLOSE Database Option to OFF


You can go to Your Database and Right Click on it. Click on Properties on the right, click menu and it will bring up the following screen. Over here you should change the Auto Close value to FALSE.


0 comments :

Post a Comment