THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » metadata » 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
  • Connect Digest : 2010-01-22

    Give us easier to read execution plansMichelle Ufford (@SQLFool) recently asked for help pinpointing the most expensive node(s) in a complicated execution plan.  Mladen Prajdic (@MladenPrajdic) has a useful workaround; he coded up a quick query to parse the showplan XML and order results by cost descending.  The Connect item that would ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement