Performance Studio 1.6.0 is released! Some visual polish, some bug fixes, and a whole lot of smart query plan analysis from Joe Obbish.

A special 4.20 release of my SQL Server performance troubleshooting scripts!

Aside from bug fixes and performance improvements, you can now log sp_QuickieStore output to tables, and sp_HumanEventsBlockViewer will show you top blocking queries in the analysis results.

Notable New Features:

• Host OS column in Server Inventory
• Offline community script support for air-gapped installs
• MultiSubnetFailover for Always On AG listeners

Notable Fixes

• Dashboard UI hangs on auto-refresh
• Deadlock count resets
• Lite auto-refresh skipping
• upgrade filter patch version handling
• memory leaks on tab close
• MCP query optimization for large databases
• PlanAnalyzer sync from PerformanceStudio

Wanna vote on the future of the monitoring tool?

• Head over here.

Wanna contribute?

• I've got some help-wanted issues open here.

This release is all about expanding and refining the query plan analysis rules. I started out capturing everything, which could be pretty noisome in some cases, and drown out some of the more important stuff. There's also a lot more going on with the wait stats analysis, available in actual execution plans.

Friend of the Repo Joe Obbish has been giving me a lot of great feedback that I've been incorporating to make this all a lot smarter and more clear, too. He is very smart.

And, in case you missed it, I've made a website with the same analysis engine as Performance Studio: https://plans.erikdarling.com/

All of the analysis is in-browser, and sharing is entirely optional. I don't want your XML.

The release notes have pretty pictures in them. You should click the link if you want to see the pretty pictures.

This release (and the latest release of Performance Studio) are both fully signed by SignPath, so the false malware detection should be gone now. If you still see them, know that I've done all I reasonably can here. Other certificate singing options are $700 a month, and no one's paying for these in a way to make that tolerable.

Anyway, the biggest additions here were in the UI/UX department, giving you better metric correlation and comparison options. I've also added a query performance heat map, so you can easily see which ones stick out and when.

Anyway, happy monitoring!

Powered by the same analysis engine as Performance Studio. XML doesn't leave your browser, so you can stay private. No robots, no files saved, no identifiable links.

As always, a big MERCI is due to MON AMI rferraton, for all the nifty little UI/UX tweaks he's been adding in here.

For my part, I mostly tried not mess anything up, while adding in some stuff that I think is pretty handy.

1. We're using Microsoft's own ScriptDOM for T-SQL parsing now. Thanks for that.
2. If you're in the Query Editor tab, you can look up module definitions (stored procedures, etc.) along with the definition of any tables, and their indexes.
3. You can look up table and index definitions by right clicking on plan operators that acquire data

Points 2 and 3 obviously require that you connect to the server/database that owns those objects, but hopefully that's obvious enough from their descriptions.

I also "imported" a personal favorite feature of mine from Plan Explorer, which shows a count of non-clustered indexes that are maintained along with the Heap/Clustered Table in narrow modification query plans.

As always, happy tuning out there.