We started working with my Comprehensive Database Performance Health Check service and found very interesting details from the server cache.
Removing a Bad Plan From Cache Without Clearing Everything
Remove one bad plan from cache by handle, compare narrower recompilation choices, and fix the cause so the plan stays healthy.
SQL SERVER – Script to Get Compiled Plan with Parameters From Cache
A script I use in every Health Check: get the compiled plan with parameters from cache, so you can see what values the plan was built for.
SQL SERVER – List Query Plan, Cache Size, Text and Execution Count
A workshop attendee asked how to see the query plan, cache size, text and execution count for queries. This simple query lists all of them from the plan cache.
What is Clean Buffer in DBCC DROPCLEANBUFFERS? – Interview Question of the Week #215
What is a clean buffer in DBCC DROPCLEANBUFFERS? No one had asked me this in 20 years, so here is the answer in the simplest words I could find.
SQL SERVER – Cleanup Plan Cache For a Single Database
After tuning a client’s database, a DBA rushed to run DBCC FREEPROCCACHE for the whole server. Here is how to clean up the plan cache for a single database instead.
SQL SERVER – Finding The Oldest Query Plan From Cache
A health check client asked how to see the oldest query plan in the cache. Here is the simple script I use, with execution count and elapsed time too.