Tag Archive for Plan Cache

pass plan cache whisperer

PASS Summit Session Follow-up: The Plan Cache Whisperer

I’ve wrapped up my session at my first session at this year’s PASS Summit.  My session this Thursday was The Plan Cache Whisperer: Performance Tuning SQL Server [DBA-313]. The session appears to have gone really well and the content has been uploaded to the PASS Summit for download.  To provide access to the materials now, the slide deck…

nose picking

Can You Dig It? – Find All Plans for a Database

With today’s SQL Server instances, there easily be anywhere from a dozen to a hundred databases on a single SQL Server instance.  In fact, on my laptop, I currently have almost two dozen databases and these are just from working on projects. Setup a SharePoint server and add a few sites and you’ll easily see…

Can You Dig It? – Determining Index Plan Usage

A while back I was asked, if you can use the plan cache to determine which plans are using specific indexes.  The answer is, of course, yes, you can.  And it’s important that people, especially DBAs, understand how to do this.  Usually during index analysis, we concern ourselves with whether an index is being used.…

Can You Dig It? – Plan Cache Series

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…

Can You Dig It? – StmtSimple Element

We’re up to the seventh post on the in the plan cache series.  This time we’ll be talking about the last of the possible children for the Statements elements – the StmtSimple element.  StmtSimple, commonly referred to as statement simple, can contain the plan information for a query plan, a store procedure, or a user…

Can You Dig It? – StmtCursor and StmtReceive Elements

Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post. She can dig it! D Sharon Pruitt A few posts ago in the plan cache series I discussed the children for the Statements element.  I’ve gotten through two of the elements and in this post we’ll be…