Posts Tagged: Plan Cache

pass plan cache whisperer

PASS Summit Session Follow-up: The Plan Cache Whisperer

Posted by & filed under , .

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 […]


Can You Dig It? – Determining Index Plan Usage

Posted by & filed under , , , , , , , , .

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. […]