Add "Max Duration" column to all query lists (Top Queries, Top Procedures, Top Querystore ...)

[sandimschuh]

Problem Statement

The maximum duration of a query is often crucial for detecting impending timeouts. Many applications use a standard query timeout of 30 seconds. If a query has a maximum duration that approaches this threshold, it may be a sign of an impending production stall due to these timeouts.

Proposed Solution

Add a "Max Duration (ms)" field to all relevant views.

Use Case

I often sort the lists by max duration.

Scope

Please indicate which component(s) this affects:

• [ x] Full Dashboard
• [ x] Lite
• [ x] SQL collection scripts

IMPORTANT: If you're going to contribute code, please read the contributing guide first.

[erikdarlingdata]

@sandimschuh This is a good issue, but we do collect that column, It's in the drill downs off the various aggregated query performance views. If you double click on a query, you can see the full set of collected metrics.

It's not perfect right now, because it really only gets the top by total duration. Long term, I need to change that (and the name of those tabs) so they're sortable from the source, not just from what shows up there.

I'm only closing this because it needs a different fix in a different way. For now, keep the ideas coming!