Browse by Tags

• query plans
• seminars
• SQL Server 2008
• training

• Geek City: Plan Caching Internals

  This Friday is the last of my summer seminars. On August 27, I am presenting on plan caching, plan reuse and recompile and plan cache metadata. This is one of my favorite topics to talk about, because a lot of the information is not very widely known, Read More... Posted Monday, August 23, 2010 11:04 AM by Kalen Delaney | 0 Comments Filed under: metadata, plan cache, query plans, seminars, training

• Geek City: Clearing a Single Plan From Cache in SQL Server 2008

  I just today found out about something that was in plain sight in the Books Online... but the documentation is so vast, I haven't discovered everything yet. I blogged about clearing a single plan from cache in SQL Server 2005 a while back, and mentioned Read More... Posted Friday, October 31, 2008 5:43 PM by Kalen Delaney | 4 Comments Filed under: metadata, plan cache, SQL Server 2008

• Geek City: Reducing Cache Bloat and a Metadata Bug

  I've been running some tests with the new SQL Server 2008 configuration option 'optimize for ad hoc workloads' which is intended to reduce cache bloat due to holding onto plans for single use ad hoc queries. This option will allow a new type of cached Read More... Posted Wednesday, October 29, 2008 5:43 PM by Kalen Delaney | 1 Comments Filed under: metadata, plan cache, seminars