What is the difference between Sum and Count with Database Execution Count measure

Question

Question by Stanislav P. · Oct 06, 2016 at 11:29 AM · appmon database 6.3+

What is the difference between Sum and Count with Database Execution Count measure

Hi guys,

I am charting the Database Execution Count as a measure and when I toggle between Sum and Count under Aggregation I am seeing different values. The Sum values are much higher than the count values. I think the "Count" aggregate tells us how many PurePaths were calculated for this measure and "Sum" tells us the how many database executions were made in a given time frame. Is this correct or I am wrong?

Thanks,

Stan

db-execution-count.png (90.7 KiB)

1 Show 2

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Mohd S. · Jan 19, 2019 at 04:49 PM 0

Share

@Stanislav P.

Just curious, is this screenshot part of Dynatrance installed on-premise or on AWS? I was using AWS subscription, so would like to try out if this service/view is possible in AWS.

Babar Q. Mohd S. · Jan 20, 2019 at 10:58 AM 0

Share

Hello @Mohd S.

This is all about AppMon and not Dynatrace.

Regards,

Babar

Answer 1 · 2016-10-06T13:30:19Z

Best Answer

Answer by Rob V. · Oct 06, 2016 at 01:30 PM

Hi Stan,

Yes, "count" is showing you how many samples were processed in that time interval. The "sum" is, as you figured, summing up the total of the results of each sample. So if you had three of these in a 10-second interval with "execution counts" of 10, 20, and 30, the count for that interval would be 3 and the sum would be 60.

Rob

2 Show 1 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Stanislav P. · Oct 06, 2016 at 02:03 PM 0

Share

Thanks a lot Rob.

Answer 2 · 2016-10-06T13:35:26Z

Best Answer

Answer by Taneshaa t. · Oct 06, 2016 at 01:35 PM

@Stanislav P.

https://answers.dynatrace.com/questions/93939/what-is-the-difference-between-sum-vs-count-with-n.html

1 Show 1 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Stanislav P. · Oct 06, 2016 at 02:15 PM 0

Share

Thanks Taneshaa.

What is the difference between Sum and Count with Database Execution Count measure

2 Replies

Join the conversation!

NAM 2019 SP3 is available

LIVE WEBINAR

Follow this Question

Related Questions

Forum Tags