How to show top 10 time consuming database statements in dashboard?

[srinivasarao_as]

Hi Team,

could you please help me with how to create a dashboard to display top 10 time consuming database statements ?

Thanks&Regards

Srinivas

[Christophe_N · Accepted solution]

Hi,

I don't think there is builtin metric for db calls, and even, this may be different per DB technoology ..

What I did :
 - I created multidimensional view with expected data

 - I added the link to multidimensional view in a text tile.
but I agree, not easy to display requests.

Maybe it would be easier by tagging as keyrequests (if it is always the same requests..) , there are some additional metrics for key requests.
For example : builtin:service.keyRequest.response.client may apply to databases

Christophe

[srinivasarao_as]

Hi Christophe,

Thank you. I will try as you suggested.

Thanks&Regards

Srinivas

[AntonioSousa · Accepted solution]

While I have not done this before, you should be able to do it by creating an MDA, and then creating metrics in the dimensions that you want. You should then be able to pin them to the dashboard.

[srinivasarao_as]

Hi Antonio,

Thank you. 

Thanks&Regards

Srinivas