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

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

srinivasarao_as — Tue, 30 May 2023 13:33:38 GMT

Hi Team,

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

Thanks&Regards

Srinivas

Re: How to show top 10 time consuming database statements in dashboard

Christophe_N — Tue, 25 Jan 2022 09:08:56 GMT

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

Re: How to show top 10 time consuming database statements in dashboard

AntonioSousa — Tue, 25 Jan 2022 09:18:52 GMT

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.

Re: How to show top 10 time consuming database statements in dashboard

srinivasarao_as — Tue, 25 Jan 2022 10:41:06 GMT

Hi Christophe,

Thank you. I will try as you suggested.

Thanks&Regards

Srinivas

Re: How to show top 10 time consuming database statements in dashboard

srinivasarao_as — Tue, 25 Jan 2022 10:47:24 GMT

Hi Antonio,

Thank you.

Thanks&Regards

Srinivas