标题: Tips and Techniques to Expand the& [打印本页] 作者: Rex 时间: 2008-6-17 20:44 标题: Tips and Techniques to Expand the Power of AC
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
