topic Re: Open Discussion - Interpret trace in Dynatrace Managed Q&A

Open Discussion - Interpret trace

Malaik — Wed, 21 Feb 2024 06:04:08 GMT

Hello All,

how would you interpret the bellow trace,

Bellow Queries are taking 1.5sec each,

after checking with database team, same queries are taking around 40msec.

Why its network I/O? is it because we are monitoring the calls from application server, so network time and processing are also counted?

Thanks.

Re: Open Discussion - Interpret trace

Mizső — Wed, 21 Feb 2024 06:34:01 GMT

Hi @Malaik

You mentioned that the same queries are taking 40ms. One query or 47/50 queries are taking 40ms? If one and you multiply 47 or 50 times then it could be 1,5 - 2 sec (1500ms - 2000ms).

Best regards,

Mizső

Re: Open Discussion - Interpret trace

Malaik — Wed, 21 Feb 2024 06:46:55 GMT

Yes thanks @Mizső this is what I'm thinking.

Thanks and good day.

Re: Open Discussion - Interpret trace

PacoPorro — Wed, 21 Feb 2024 07:36:54 GMT

you have around 300 db calls in this trace.

2 additional ms per db call means 0.6 seconds.

Re: Open Discussion - Interpret trace

radek_jasinski — Wed, 21 Feb 2024 11:06:41 GMT

In the case of such a number of queries, I would be interested to know whether you have correctly set the cache for database queries on the application side (a very common problem on environments with Hibernate).