Tips and Techniques to Expand the&

Rex

AUTO_CLOSE

Generally, do not enable
--Impacts all databases on the SQL instance
--Unlike ACT! config setting, not just local databases
A viable option…
--For single-user “road warrior” such as a Sync User
--Machine with less RAM (<1GB RAM) and/or many other applications running
--Desire to copy databases when not in-use as a backup approach (could be a security concern)


AUTO_SHRINK

Ok to leave AUTO_SHRINK enabled when…
--Database Maintenance not regularly performed
--Low data volatility
--Periodic database usage (low contention)
Disable AUTO_SHRINK if…
--Workgroup database with high online usage
--Volatile data (deletes, Purge Old Data, etc.)
--Regular Database Maintenance is performed
--CPU spikes, slow performance or timeouts