ITPro Today logo
Active DirectoryShould I Optimize My SQL Server Instances for Ad Hoc Workloads?Should I Optimize My SQL Server Instances for Ad Hoc Workloads?
In general, I recommend that the SQL Server 2008 configuration option be enabled on all my customers’ servers. The original idea behind the option was to reduce plan cache bloat caused by ad hoc workloads, but even if you don’t have a lot of intentionally ad hoc workloads, you might still save cache and reduce bloat of dynamically executed strings and other internal code.
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.