I'm looking for more graphical real-time monitoring out of DBADash, specifically showing 'total waits per query'. I've found this is the best way to show problem queries over time, and what queries are currently causing problems. Solarwinds DPA does this extremely well. Check out their screenshots/videos for examples. Adding this capability to DBADash would put this tool on-par or really exceeding a lot of commercial offerings.

To implement this feature in DBADash, there are two parts. The first is increasing query collections, ideally all queries. With v3.31, we can now capture task waits, which we need for this new feature. The problem is that SQLRunningQueries.sql is rather heavy in our environment. It runs in 3-5 seconds, returning 200-250 rows. Ideally, we'd have a lightweight query we could run more often to capture a minimal/filtered amount of data showing query waits. I’ve attached an example query that runs in <1 second in our environment.

The second is to graph this data over time to make it easy to understand. A bar graph showing waits per query over time. (For example, per-hour over a day, or every 10 minutes over an hour) I've attached an example query showing how to get this information from the existing task waits. It's not very useful without increasing query collection time. Ideally, we could drill into the bar graph to show the query stats, waits, source server/login/etc, for troubleshooting.

DBA.Dash.Wait.Stats.Query.sql