topic Re: Add MDA as a tile within Dashboard in Dashboarding

Add MDA as a tile within Dashboard

Konstantin_Mavr — Fri, 24 Jan 2020 15:48:00 GMT

Hi,

I am looking into a way to attach a MDA (Multi-dimensional analysis) as a chart to specific Dashboard. After browsing across Dynatrace community there are 2 really interesting articles which stated that such action is possible:

https://www.dynatrace.com/news/blog/nextgen-multidimensional-analysis-introduces-calculated-metrics-for-better-dashboarding-and-ai-driven-answers/

https://www.dynatrace.com/news/blog/custom-metrics-for-services-enrich-dynatrace-ai-and-dashboarding-capabilities-eap/

My aim is to monitor the slowest query executed towards the DB. A custom metric can be created which will allow to monitor the queries and their count based on the custom created metric.

Has anyone used the custom calculated metrics?

Cheers,

Konstantin

Re: Add MDA as a tile within Dashboard

Julius_Loman — Mon, 27 Jan 2020 07:07:44 GMT

If you are interested in response time of a particular DB query, you can mark it as key request and then pin that to dashboard. It's not straightforward, but it works.

Calculated metrics can be only measured at non-database services and you can only calculate total time spent in DBs or number of calls per request.

The slowest DB query from a service can be very volatile and highly dependent on the service request. What is your use case? (your first link is publicly accessible)

Re: Add MDA as a tile within Dashboard

Konstantin_Mavr — Thu, 30 Jan 2020 09:00:04 GMT

I am looking into a way to monitor the slowest running queries and their number, the largest occurances of the same queries. They will be part of a Performance Dashboard which will be used during Delivery, and Early Live Support of the application.