Tag: ad hoc workloads
Should you use the Optimize for ad hoc workloads option in SQL Server 2008?
Brett Hawton – 11 October 2010 Microsoft has given us this seemingly wonderful option in SQL Server 2008 Optimize for ad hoc workloads. However when should a site consider turning it on and when is it best left alone? The short answer: It depends… In order to use any option on SQL Server (or any [...]
Posted: October 11th, 2010 under Memory.
Tags: ad hoc workloads, memory consumption, query plans
Comments: 3
