Can You Dig It? – Parallelism in the Plan Cache

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 lead in to this post, I talked about how the plan cache can be a gold mine of information.  There are a number of places that one can … Continue reading Can You Dig It? – Parallelism in the Plan Cache

Can You Dig It? – The Plan Cache

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 this new series of posts, I plan to investigate the SQL Server plan cache.  We’ll start with a little introduction of the plan cache and move into ways in … Continue reading Can You Dig It? – The Plan Cache

Really Search Cache for Execution Plans

Today’s stored procedure that you can use in your DBA database is a re-hash of a post I did a couple months ago.  The reason for re-hashing the procedure is that when I used it last week I found out there were some serious issues with its results.  Some plans were being duplicated and the … Continue reading Really Search Cache for Execution Plans