Home Search

DriveWorks Pro 22
How To: Optimize A SQL Database (KB17071701)

Send Feedback

How To: Optimize A SQL Database

Auto Close

SQL databases are found to be more performant with the Auto Close option set to False.

New shared groups created before v15.1 will have this set to True. To change:

From SQL Management Studio...

  1. Right click on the database from the list of databases.
  2. Select Properties.
  3. From the Options page select the Auto Close option in the Automatic section.
  4. Change the value from True to False.

See Microsoft recommendations for setting the auto close database option for more information.

DriveWorks 15 Service Pack 1

From this version all new Shared Groups created will have this option set to False automatically.

Knowledge Base Article Ref:KB17071701