Performance | Memory | Plan Cache

A high level breakdown of the plan cache. The report is divided into 3 sections.

Cache Counters

The number and memory used by SQL plans (adhoc SQL) and object plans.

What It ShowsComments
NameSQL Plans or Object Plans
TypeCACHESTORE_SQLCP or CACHESTORE_OBJCP
Pages
Pages in use
Entries
Entries in use

Hash Tables

This gives an indication of how fragmented the memory has become and how often a plan is available for reuse.

What It ShowsComments
NameSQL Plans or Object Plans
TypeCACHESTORE_SQLCP or CACHESTORE_OBJCP
Buckets
In use
Min / max length
Average length
Hits
Misses

Cache Breakdown

This shows the number and size of adhoc and object plans, broken down by the number of times each has been used.

What It ShowsComments
Use countsThis is a range, eg. Single Use, 2 - 10, 11 - 100, More Than 100
Object type
Number of plans
Total plan size
< Performance | Memory | Clock Hands Performance | I/O >