Auto Close Option

Legacy Poster

• 8 octobre 2014 17:55

Not having been the one to set up our BarTender SQL Server database, several items in Event Viewer led me to find that it was set to have the "AUTO_CLOSE" option set to ON. After reading several sources about why this is a bad practice, I'm wondering if there is any reason I shouldn't turn this OFF?

0

• 

  Ian Cummings

  Modérateur

  ★ BarTender Hero ★

  • 9 octobre 2014 09:40

  I'll look into this to find out what our default behaviour is in different scenarios, and why we use the settings we do.

   

  It seems to be the case that if a database is created with the Express edition of SQL Server, then by default the "AUTO_CLOSE" option set to ON.  I would be interested to know if the System Database Setup wizard has this option set to OFF when using a full edition of SQL Server.

   

  The below article has a good write-up on this issue, and give information on how to change this setting using the SQL Management Studio.  After reading the below article it would indeed seem to make sense to default this setting to OFF.

   

  http://sqlmag.com/blog/worst-practice-allowing-autoclose-sql-server-databases

  0
• 

  Ian Cummings

  Modérateur

  ★ BarTender Hero ★

  • 9 octobre 2014 11:31

  I've asked development for their input on this matter.  Meanwhile, if the BTSDB will be in frequent, transactional use, such as when BarTender is implemented in some kind of automated solution, then I would suggest you set this option to false.  If and until development give me information to the contrary, then this would be my recommendation.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 9 octobre 2014 17:51

  ... I would suggest you set this option to false.  If and until development give me information to the contrary, then this would be my recommendation.

   

  Thanks!

  0
• 

  Ian Cummings

  Modérateur

  ★ BarTender Hero ★

  • 10 octobre 2014 07:46
  Information from development:

   

  1. AUTO_CLOSE is set to False by the script which creates the system database.

   

  2. As a test we found that a database created by the wizard for SQL Server Express 2012 left the AUTO_CLOSE set to True.

   

  3. If the user previously created an empty database and used our setup wizard to create the BarTender System Database schema on top of it, then in this case it would be possible for the AUTO_CLOSE option to end up as True.  We're going to look at using the setup script to set this back to False in such a case.

   

  And just to confirm: we recommend you set this item to False.

  0

Vous devez vous connecter pour laisser un commentaire.