http://www.sqlservercentral.com/blogs/stratesql/2011/02/18/can-you-dig-it_3F00_-_1320_-plan-cache-series/

Printed 2014/11/25 06:52PM

Can You Dig It? – Plan Cache Series

By StrateSQL, 2011/02/18

3295969599_eb16a58118_m1
She can dig it!
D Sharon Pruitt

A few PASS Summit’s ago, I became interested in the information available in the Plan Cache.  As part of that interest, I started digging into the plan cache to  find out what is there and available to be pulled out.

Some of those investigations led to a few presentations; which have in turn led to this blog series.  Rather than number these out and put a timeframe around them, I’ve instead opted to post here are there when I have new plan cache queries and to publish information from my presentations.

The posts in this series to date are:

As more posts are published, I’ll add them to this list.  Enjoy digging into your plan cache.

Related posts:

  1. Can You Dig It? – SHOWPLAN XML Structure
  2. Can You Dig It? – The Plan Cache
  3. Can You Dig It? – Parallelism in the Plan Cache


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.