cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Looking to upgrade from Dynatrace Managed to SaaS? See how

Open Discussion - Interpret trace

Malaik
DynaMight Champion
DynaMight Champion

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.

 

Malaik_0-1708495238349.png

 

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.

 

Sharing Knowledge
4 REPLIES 4

Mizső
DynaMight Guru
DynaMight Guru

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ő

Dynatrace Community RockStar 2024, Certified Dynatrace Professional

Malaik
DynaMight Champion
DynaMight Champion

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

Thanks and good day.

Sharing Knowledge

PacoPorro
Dynatrace Leader
Dynatrace Leader

you have around 300 db calls in this trace.

2 additional ms per db call means 0.6 seconds.

PacoPorro_0-1708501002586.png

 

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).

Have a nice day!

Featured Posts