TheSQLGuru (4/22/2016)

---

Lynn Pettis (4/22/2016)

---

TheSQLGuru (4/22/2016)

---

Great thinking for autoclose being a cause of the repeated long initial run times! Actually it is hard to think of a situation where autoclose should be turned on for a database.

SQL Express loaded on a desktop/laptop supporting a local application.

I have clients with tens of thousands of that scenario and not a one has autoclose on. The data is just going to be lifted up off of disk again after each closure. I suppose if the app is only run once per NN time (long amount of time there) and the delay inherent is acceptable.