I was curious why or how this option would have been set in our ServiceDesk MSSQL Database? This is not a normal thing to be set on a database and can cause some performance issues. We have been having some problems occasionally with query’s blocking, and this might be a contributing factor.

Please see these two articles for explanation:

http://www.itprotoday.com/worst-practice-allowing-autoclose-sql-server-databases

https://www.brentozar.com/blitz/auto-close-enabled/

See screenshot attached