Subscribe to this blog
Archives: July 2010
Hit and miss
Or “Monitoring plan cache usage”
For people interested in the details of how SQL is using and reusing execution plans, there are some useful events in profiler for watching this in detail, under the Stored procedure group:
- SP:CacheMiss
- SP:CacheInsert
- SP:CacheHit
- SP:CacheRemove
- SP:Recompile
- SP:StmtRecompile
Additionally there’s the SQL:StmtRecompile event… Read more
1 comments, 117 reads
Posted in SQL In The Wild on 27 July 2010