SSC Clinic: Can Implementing "Optimize for Ad Hoc Queries" Boost Performance for the SQLServerCentral.com and Simple-Talk.Com SQL Servers?
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Thu, 14 Jun 2012 06:00:00 UT
Indexed on
2012/06/15
15:24 UTC
Read the original article
Hit count: 250
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.
 |
Get smart with SQL Backup Pro Get faster, smaller backups with integrated verification. Quickly and easily DBCC CHECKDB your backups. Learn more.  |
© SQL Server Central or respective owner
