# Do Database consumption calculation include time spent in Network I/O.?

**URL:** <https://community.dynatrace.com/t/do-database-consumption-calculation-include-time-spent-in-network-i-o/22116>\
**Category:** Open Q&A\
**Tags:** databases, network-monitoring\
**Created:** [September 30, 2019, 9:27am UTC](https://community.dynatrace.com/t/do-database-consumption-calculation-include-time-spent-in-network-i-o/22116 "2019-09-30T09:27:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![praveen\_kumar\_r](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@praveen\_kumar\_r](https://community.dynatrace.com/u/praveen_kumar_r)\
**Post date:** [September 30, 2019, 9:27am UTC](https://community.dynatrace.com/t/do-database-consumption-calculation-include-time-spent-in-network-i-o/22116/1 "2019-09-30T09:27:47Z")

</div>

Wanted to understand is time spent in Network I/O is used to calculated time spent in Database consuming..? For Ref.

 ![22015-1569833409410.png](https://global.discourse-cdn.com/dynatrace/original/3X/0/c/0ca7c98f2fddb853b44408e718183196fdcb4ec3.png)

Response time for the request is 51 s, The time spent in Network I/O is 42 s and time spent in database consuming is spent is 45 s.

We never observed Network I/O showing up in past PurePath processing time.

In below PurePath processing time, Database consuming is 20 s, but Dyntratrace doesn’t show Network I/O even though there was Database calls.

 ![22016-1569833842739.png](https://global.discourse-cdn.com/dynatrace/original/3X/4/b/4b323dece0cb671328bad80ce64ab8c47d6f844c.png)

Also Response time calculation consider Network I/O or Database Consuming..?

---

<div class="post-metadata">

**Author:** ![skrystosik](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/skrystosik/32/21133_2.png) [@skrystosik](https://community.dynatrace.com/u/skrystosik)\
**Post date:** [September 30, 2019, 9:34am UTC](https://community.dynatrace.com/t/do-database-consumption-calculation-include-time-spent-in-network-i-o/22116/2 "2019-09-30T09:34:31Z")

</div>

Other means time that cannot be assigned because of some conditions (it may sometimes be IO as well). In general Dynatrace is monitoring DB statements from application ednpoint (mysqli, JDBC, [ADO.NET](http://ADO.NET)&nbsp;etc). So we do not exactly know how log statement was processed on Database endpoint. We know that whole transactions from aplication point of view took some time. For example 40 s. In this is network communication, aquisition connection pool (if it’s not separate node on PP), executing statement on DB engine etc.

Sebastian

---

<div class="post-metadata">

**Author:** ![praveen\_kumar\_r](https://avatars.discourse-cdn.com/v4/letter/p/e99b99/32.png) [@praveen\_kumar\_r](https://community.dynatrace.com/u/praveen_kumar_r)\
**Post date:** [September 30, 2019, 9:58am UTC](https://community.dynatrace.com/t/do-database-consumption-calculation-include-time-spent-in-network-i-o/22116/3 "2019-09-30T09:58:04Z")

</div>

[@sebastian k.](https://answers.dynatrace.com/users/15061/view.html) Thank you for quick response. One question - Response time calculation consider Network I/O or Database Consumption or both - which I dont think is the case.

---

<div class="post-metadata">

**Author:** ![skrystosik](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/skrystosik/32/21133_2.png) [@skrystosik](https://community.dynatrace.com/u/skrystosik)\
**Post date:** [September 30, 2019, 10:48am UTC](https://community.dynatrace.com/t/do-database-consumption-calculation-include-time-spent-in-network-i-o/22116/4 "2019-09-30T10:48:18Z")

</div>

Both, as I said. Dynatrace does not know what was time spend on network I/O and what on DB engine (and other steps if they are any). Dynatrace can only calculate it as whole transaction. In this case SQL Response time is calculate on all those parts of transactions that you’ve mentioned.

Sebastian
