cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to show top 10 time consuming database statements in dashboard

srinivasarao_as
Organizer

Hi Team

 

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

 

Thanks&Regards

Srinivas

4 REPLIES 4

Christophe_N
Contributor

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

Hi Christophe,

 

Thank you. I will try as you suggested.

 

Thanks&Regards

Srinivas

AntonioSousa
DynaMight Guru
DynaMight Guru

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.

Antonio Sousa

Hi Antonio,

 

Thank you. 

 

Thanks&Regards

Srinivas