topic Queries per request in Dynatrace in Open Q&A

Queries per request in Dynatrace

msmith1 — Wed, 10 Mar 2021 06:57:36 GMT

HI all,

I have 2 view, top requests and number of calls to databases.

What I'd like to see is which requests make the most database calls?

Thank you.

Re: Queries per request in Dynatrace

Babar_Qayyum — Wed, 10 Mar 2021 08:30:55 GMT

Hello @msmith1

Try the following method:

Using Diagnostic tools > To web requests > Service-level backtrace of requests/ or service flow.

Regards,

Babar

Re: Queries per request in Dynatrace

trevor_masseng1 — Mon, 29 Mar 2021 16:10:49 GMT

Once you're at the view Babar mentioned, you'll want to change the metric you are displaying.
This metric is also available to query through the Metrics v2 API or plot in a dashboard.

Re: Queries per request in Dynatrace

msmith1 — Wed, 07 Apr 2021 13:08:33 GMT

Thank you for replying, my apologies for my delayed response.

This is what I had in appmon and this is what I have in dynatrace. The requests outweigh the db calls it's hard to see an actual trend (and that's just 7 days worth).

Any suggestions?

thanks