SQLServerCentral.com Articles tagged ad hoc querieshttp://www.sqlservercentral.com/Articles tagged ad hoc queries posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)SSC Clinic: Can Implementing "Optimize for Ad Hoc Queries" Boost Performance for the SQLServerCentral.com and Simple-Talk.Com SQL Servers?With the introduction of the instance-level option “optimize for ad hoc workloads” in SQL Server 2008, DBAs have a tool to deal with a problem known as plan cache pollution, or plan cache bloat. It’s often caused when one-time use ad hoc queries are sent to SQL Server from Object-Relational Mapping (ORM) solutions, such as LINQ, NHibernate, or Entity Framework. The problem can prevent SQL Server from using its available memory optimally, potentially hurting performance.

]]>http://www.sqlservercentral.com/articles/SQLServerCentral/91250/Thu, 14 Jun 2012 06:00:00 UThttp://www.sqlservercentral.com/articles/SQLServerCentral/91250/