topic Re: Use the available metric to monitor a database statement and add to dashboard in Dashboarding

Use the available metric to monitor a database statement and add to dashboard

Greeshma — Thu, 25 May 2023 06:53:49 GMT

Hi Team,

We would like to get the request count of a specific database statement (with or without splitting database) from the data explorer so that we can monitor this in the dashboard.
I tried passing the query as "dt.entity.service_method",entitySelector("type(service_method),entityName.in(~"MY QUERY~")" in the data explorer but was of no luck. Can you please guide me on how this can be achieved or is it even possible to monitor the metrics of a particular database statement in dynatrace?

Regards,

Greeshma

Re: Use the available metric to monitor a database statement and add to dashboard

Mizső — Thu, 25 May 2023 06:54:39 GMT

Hi @Greeshma,

Which metric do you use?

builtin:service.keyRequest.count.total?

Best regards,

Mizső

Re: Use the available metric to monitor a database statement and add to dashboard

Greeshma — Thu, 25 May 2023 07:01:46 GMT

Yes, I tried builtin:service.keyRequest.count.total metric as well as other metrics in which I can filter using the request name.

data explorer provides results when the request name is a web request but not for a sql query

Regards,

Greeshma

Re: Use the available metric to monitor a database statement and add to dashboard

Mizső — Thu, 25 May 2023 07:40:05 GMT

Hi @Greeshma

Have you maked this sql query as a key request?

I hope it helps.

Best regards,

Mizső