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. [...]
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post. It’s been a while since the last plan cache series post. In the last few posts, I was focusing on specific attributes. Instead of continuing on that vein, I want to cover a use case that fit [...]
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 [...]
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post. It’s the eighth post in the plan cache series. I hadn’t expect to take as many days off from this due to the 31 Days of SSIS, but that one had a stricter time table that I [...]
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post. She can dig it! D Sharon Pruitt It’s the eighth post in the plan cache series. I took a few days off to start up a new blog series, I had considered holding that series until March [...]
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 [...]
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 [...]
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 couple posts ago in the plan cache series I discussed the children for the Statements element. This next post will focus on the second of the five possible child [...]
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post. She can dig it! D Sharon Pruitt The last post in the plan cache series discussed the children for the Statements element. As I noted in that post, there are five possible children. This post will focus [...]
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post. She can dig it! D Sharon Pruitt In the last couple plan cache posts, I talked about a couple items that are available within the SHOWPLAN XML for an execution plan. These posts looked at how to [...]
_1262.png)
