Browse by Tags

• DBCC
• memory management
• SQL Server Magazine
• syscacheobjects

• Geek City: Q & A on my Plan Cache Sizing article in SQL Server Magazine

  My December article in SQL Server Magazine , called Managing Plan Cache Size, expands on the information I talked about in a post last month on the limits of plan cache . A reader of the article ask some questions on the SQL Server Magazine web site, Read More... Posted Saturday, December 15, 2007 8:00 PM by Kalen Delaney | 5 Comments Filed under: plan cache, plan guides, SQL Server Magazine, memory management

• Geek City: Clearing a Single Plan from Cache

  Caching and reusing query plans is both a good thing and a bad thing. Saving costs of recompilation for a query that is run repeatedly can be a good thing. Using a cached plan that is not appropriate can be a very bad thing. What do you do if you have Read More... Posted Saturday, September 29, 2007 12:18 PM by Kalen Delaney | 10 Comments Filed under: plan cache, syscacheobjects, DBCC, plan guides