sp_BlitzCache ChangeLog

sp_BlitzCache® Change Log

Interested in the exciting back-story of our free sp_BlitzCache®? Here’s the play-by-play history:

Now with errors when required values are set to NULL. Thanks to Raul
Gonzalez for pointing this out.
Changing default @top to 10
Added a @skip_analysis to avoid the XML processing overhead
Added QueryHash and QueryPlanHash to @export_to_excel and expert mode
Adding sort order for recent compiles.
Fixing potential INT overflow in totals temp table
Fixing slow sort performance on xpm and friends
Added compilation info (memory, CPU, time) and plan size to output
Re-structured XML processing for more better performance

adds filtering on database name, shows memory grants in expert mode, shows parent object names for statements from stored procedures, and a @sql_handle parameter to filter queries.

Added query plan cost to Excel output, miscellaneous bug fixes and improvements.

Fix to remove confusing implicit conversion checks. Warnings will only be generated when a plan affecting convert is in place.

Hotfix – Denis Gobo pointed out that the global temp table names could conflict with everyone else’s global temp table rates.

Fixed a logical error in output table detection – thanks to Michael Bluett for pointing that out.
Fixed a bug where sorting on average executions broke the query. Thanks to Andrew Notarian and Calvin Jones for submitting this.
Added @query_filter to allow output restrictions to only procedures or individual statements.
Adds a check for trivial execution plans.
Adds @reanalyze. When set to 1, this re-scans existing results rather than running all of the logic again. Bonus: contains GOTO.
Now displaying set options!

Added opserver specific output
Adding a @only_query_hashes parameter to limit results to a select set of query hashes.
Adding a @ignore_query_hashes parameter to exclude specific queries from analysis.