Pau Lo
asked on
autoclose logic
from what I read auto-close is a dangerous setting in SQL as it can lead to performance issues. But are there any situations where it would be ok/beneficial? we have some DB which are archive data and rarely queries, in this case does autoclose make sense( trying to understand the logic why a DBA set it on some DB and not others).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
When AutoClose set to ON, the database is shut down cleanly and its resources are freed after the last user exits. The database automatically reopens when a user tries to use the database again.
When AutoClose set to OFF, the database remains open after the last user exits.