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 » plan cache   (RSS)
Showing page 1 of 2 (15 total posts)
  • 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
  • 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
  • Tuning ‘cost threshold for parallelism’ from the Plan Cache

    A good while ago I was asked if it was possible to consistently produce a parallel plan by Tom LaRock(blog/twitter), and I recalled from reading Grant Fritchey’s(blog/twitter) book on Execution Plans that it was possible to do this by adjusting the ‘cost threshold for parallelism’ sp_configure option from the default of five to a value of one ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on January 19, 2010
  • Finding Implicit Column Conversions in the Plan Cache

    Last year Tibor Karaszi posted a blog post titled Match Those Types that talked about implicit data type conversions associated with mismatched data types between filter criteria and table column data types.  His blog post does a good job of covering the topic so I am not going to rehash it out here. However, at the time I was working on a ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on January 8, 2010
  • How many times has that Plan Guide been used?

    Plan guides aren't something that we tend to use everyday, and I certainly never think about the ones that I have created in my databases over the last few years.  However, recently someone asked how to measure how many times a plan guide has been used.  I expected to find some DMV/DMF that would have that kind of information aggregated ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on October 26, 2009
  • Digging into the SQL Plan Cache: Finding Missing Indexes

    This is one of those topics I planned to blog about a long time ago, but never actually got around to it, and consequently I keep having to hit search engines to find the code I provided in a forums post when I need to use it again.  A while back, I helped fellow SQL enthusiast Jeremiah Peschka (@peschkaj) out via twitter with finding plans ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on July 27, 2009
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement