top of page

Things You Can Find In The Plan Cache

Two weeks ago I delivered a presentation called “Things You Can Find In The Plan Cache” to the israeli SQL Server user group. Among the subjects we talked about were:

  1. Why the Plan Cache is needed

  2. The right ways to work in order to increase plan reuse

  3. Plan Cache Dynamic Management Views and Functions

  4. Common application problems in relate to the Plan Cache

  5. Plan Cache memory limits and age-out algorithm

  6. Querying the Plan Cache to identify problematic queries

  7. The real meaning of Recompile

  8. Querying Execution Plan XML for interesting insights

Below is the presentation itself. You might have a slight problem understanding it if you don’t know Hebrew – I hope to deliver it online in English within a few months.

Meanwhile, you are welcome to review the slides and demos.

Here are my top 5 takeaways from the presentation:

  1. Reuse is almost always a good thing (not always though). Try to maximize it to reduce memory consumption and CPU usage.

  2. Know the way your applications work and what it can do to your Plan Cache

  3. Recompile does not only mean “give me a new plan”. Know its real meaning before using it.

  4. You can get great insights about your system from querying the Plan Cache.

  5. You can get great insights from a different angle by querying Execution Plan XML (here’s an example).

In addition, here are some of the great resources I used during my preparations:




Get New posts delivered straight to your inbox

Thank you for subscribing!

bottom of page