[Update]: there is now a non-Diagnostics Pack version here.
[Update]: version 1.6 is now out. More on this blogpost.
My collegues are frequently using my SQL performance scripts, but there were some complaints that the scriptnames were a bit too long. Now if that’s the worst complaint I’ll get, I think I can handle that. But yeah, maybe they were a bit too long. So I’ve changed the scriptnames:
sql_sql_id_html.sql is now called sqlperf.sql. And stats_sql_id_html.sql is now called sqlstats.sql. The names of the example output files are changed as well (but they are now still of the old version).
But apart from the name change the scripts are also new versions. In previous versions it would retrieve statistics and statistics history data for the execution plan in memory. Now it also looks for tables/indexes mentioned in execution plans in AWR data. Too often I’m investigating SQL that is no longer in memory and this way I still get all of the statistics data I need to analyze it’s problems.