Our customer needs a dashboard with the Top 10 time consuming SQL commands in a database.
So I create a metric grouping using this regexp:
Backends\|bk(.*)\|.*Average Response Time \(ms\)
But the resulting dashboard is pretty much useless for the customer, because we get over 100 hots, and the metrics are not sorted by the Response Time value, either.
Does anyone know a solution for that?
We would ideally want a sorted Top 10.