AnsweredAssumed Answered

Top 10 SQL Response times

Question asked by Toni.Moreno on Oct 7, 2016
Latest reply on Oct 7, 2016 by Hallett_German

Good morning,

 

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.

 

Thanks!

Mikel.

Outcomes