• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
        • Enterprise Synthetic Monitoring
      • Synthetic Classic
        • Synthetic Classic Open Q&A
      • BSM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
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 (92.9 kB)
Comment
Rodrigo A.

People who like this

1 Show 2
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Mohd S. · Jan 19 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.

avatar image Babar Q. Mohd S. · Jan 20 at 10:58 AM 0
Share

Hello @Mohd S.

This is all about AppMon and not Dynatrace.

Regards,

Babar

2 Replies

· Add your reply
  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image
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

Comment
Stanislav P.
sebastian k.

People who like this

2 Show 1 · Share
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Stanislav P. · Oct 06, 2016 at 02:03 PM 0
Share

Thanks a lot Rob.

avatar image
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

Comment
Stanislav P.

People who like this

1 Show 1 · Share
10 |2000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Stanislav P. · Oct 06, 2016 at 02:15 PM 0
Share

Thanks Taneshaa.

Your answer

Hint: You can notify a user about this post by typing @username

Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Welcome to the
Dynatrace Community Forums

Check out the Forum User Guide and Forum Guidelines to learn how to get started.

Community Member of the Month
February 2019

Announcing Dynatrace's Community Member of the Month for February 2019, Larry R.! Click here to read more!

Employee Member of the Month
February 2019

Announcing Dynatrace's Employee Member of the Month for February 2019, Dave M.! Click here to read more!

Live webinar: AIOps done right through enhanced Dynatrace AI root cause detection

Learn the enhanced capabilities of the next generation Dynatrace AI root cause analysis and how to feed it with your own data sources.
Wednesday, February 20, 2019
Register today!

Live webinar: AIOps done right through enhanced Dynatrace AI root cause detection

Learn the enhanced capabilities of the next generation Dynatrace AI root cause analysis and how to feed it with your own data sources.
Wednesday, February 20, 2019
Register today!

NAM 2019 Beta is available

Would you like to have an early taste of what we have cooked up for 2019? We would love to hear your feedback and improve some of the new features. Check NAM 2019 Beta release notes.
Sign up today!

Follow this Question

Answers Answers and Comments

21 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Configuration for JUnit Test Perfomance View (Business Transaction, Measure, Sensor pack methods) 2 Answers

Glassfish JMX measure Database pool usage & Current thread count 2 Answers

Why would an Oracle database get recognized as a generic database in the Work Flow 3 Answers

Performance Warehouse data loss 2 Answers

Performance Warehouse migration - SQL Server 1 Answer

Forum Tags

nginx java dotnet docker 6.5 ios customization knowledge sharing browser agent mobileapp sensor chart 7.1 hybris 6.3+ production incidents Dynatrace Managed php javascript processes monitoring nodejs uem splunk license framework good to know installation web services plugin splitting rest webserver reports kubernetes 7.0 errors rum mainframe 6.1 account configuration forum user guide security web dashboard agent load window oneagent upgrade diagnostics search scheduler appmonsaas log analytics database performance warehouse services web performance monitoring user sessions test automation transactionflow measures business transaction migration plugins android dashlet server purelytics 6.2 rest api system profile appmon appmon 7 mobile monitoring collector adk messagebroker purepath apache guardian appmon iis 7.2 user actions dashboard mq kibana client continuous delivery unique users postgresql sensors documentation alerting auto-detection 6.3 administration
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A
      • Enterprise Synthetic Monitoring
    • Synthetic Classic
      • Synthetic Classic Open Q&A
    • BSM Open Q&A