THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » plan cache   (RSS)
  • Geek City: sp_cacheobjects for SQL Server 2012

    In a post about 4 1/2 years ago, I gave you my version of a replacement for the old pre-2005 pseudotable syscacheobjects. I called it sp_cacheobjects and created it as a view in the master database. With the sp_ prefix, the view can be accessed from any database. When testing this on SQL Server 2012, I noticed that I almost always got a lot more ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 31, 2013
  • 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, and you can have a tremendous performance impact by making sure when plans are reused when that ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 23, 2010
  • Did You Know? I'm doing 3 more online seminars with SSWUG!

    As I told you in April, I recorded two more seminars with Stephen Wynkoop, on aspects of Query Processing. The first one will be broadcast on June 30 and the second on August 27. In between, we'll broadcast my Index Internals seminar, on July 23.  Workshops can be replayed for up to a week after the broadcast, and you can even buy a DVD of ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 11, 2010
  • Geek City: Clearing Plans for a Single Database

    I know Friday afternoon isn't the best time for blogging, as everyone is going home now, and by Monday morning, this post will be old news. But I'm not shutting down just yet, and a something came up this week that I just realized not everybody knew about, so I decided to blog it. Many (or most?) of you are aware that you can clear all cached ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 21, 2010
  • Did You Know? More online seminars!

    I am in Tucson again, having just recorded two more online workshops to be broadcast by SSWUG. We haven't set the dates yet, but we are thinking about offering a special package deal for the two of them. The topics really are related and I think they would work well together. They are both on aspects of Query Processing. The first was on how to ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 22, 2010
  • 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 a rumor that there would be a new way to do this in SQL Server 2008. And then just ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 31, 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 object to be stored, which isn't the only plan, but merely a stub. There will be a corresponding ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 29, 2008
  • 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, and I have decided to use my blog to post the answers. Q:  Could you give me an ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 15, 2007
  • Did You Know? SP2 does NOT limit the amount of plan cache you can have

      As I am preparing my talk for the UK SQL Server Users Group on November 16, I was going through other presentations on plan cache management. At the PASS Conference in Denver in September there was a session on management of cache, and I was surprised to find a slide that indicated there was a hard upper limit for plan cache size, and ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 4, 2007
  • 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 plans in cache that should not be there? SQL Server 2000 and 2005 provide a way to clear ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 29, 2007
Privacy Statement