trimble-oss / dba-dash

DBA Dash - SQL Server Monitoring Tool
MIT License
262 stars 61 forks source link

UI Enhancement: Change default sort order of Execution Stats bar chart #1010

Closed chadbaldwin closed 1 month ago

chadbaldwin commented 1 month ago

This is regarding the bar charts visible on the "Performance" tab along with the itemized detail pop-up.

For the "Execution Stats" bar chart, I think it would be helpful if the sections of the bars were sorted so that the largest sections were on the bottom.

As an example, the "Waits" bar chart graph is already set up this way. But it seems the "Execution Stats" bar chart graph is instead sorted alphabetically, which can make it somewhat difficult to follow.

The only reason I thought of this is because I just recently started using the DBADashReports, and when looking at the Procedure Stats report, it too is sorted by percentage rather than alphabetically and it is easier to see what's going on.

DBADashGUI - Performance - Execution Stats: image

DBADashReports - Procedure Stats: image

DavidWiseman commented 1 month ago

Thanks for the suggestion - makes sense.

Note: The SSRS reports are no longer being developed/tested. They might provide a starting point to build on though if you want some SSRS reports.

DavidWiseman commented 1 month ago

Included in 3.11 🚀