• 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
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Michael D. · Jan 17, 2020 at 08:32 PM · appmon database purepath 7.2

Database Aggregation metric not showing true sum

We're dealing with some extremely slow database queries that aren't showing accurate aggregation metrics in the Purepath. In one example, it will show 1 x DB query in the argument column and 0.03 for the Exec Total [ms] column.

If I turn off JDBC aggregation, it shows 70,000ms in the purepath tree Exec Total column.


This discrepancy is making it very difficult to troubleshoot issues and find the slow query. A similar post here https://answers.dynatrace.com/spaces/148/uem-open-q-a_2/questions/106485/database-dashlet-exec-avg-time-and-db-time-measure.html looks like the same issue at the bottom, where @Andreas G. said the database time metric should not change just by enabling aggregation.


With aggregation enabled, the Node Details show .03 in the Time Details Exec column, and the 70,000 under the Statement Aggregation Details Execute row. But the purepath tree only shows the .03.


So with aggregation disabled, if I see this:

Argument Exec Total (ms)
SELECT * from product_prices 100.00
SELECT * from product_prices 300.00


I would expect the aggregation to show this:

Argument Exec Total (ms)
2 x SELECT * from product_prices 400.00


But instead it's picking some other java execution time and showing .02ms.


Edit:

Here's a better view of the query details: the purepath tree is displaying the Execution Time of .03ms, but the actual time is 130 seconds.


If I disable JDBC aggregation, then the purepath shows the full response time for the query.

forumss.png (28.6 KiB)
Comment

People who like this

0 Show 1
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image Michael D. · Jan 17, 2020 at 09:31 PM 0
Share

Purepath view (130 second query selected at the bottom showing .03):


Drill down to database dashlet shows the correct 130s Exec Time (except for Min = 0.00?):


pptree.png (35.0 KiB)
db-dashlet.png (8.3 KiB)

4 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image
Best Answer

Answer by Sebastian K. · Jan 18, 2020 at 06:37 AM

So what Incan suggest to you is rising support ticket. Attach there two purepaths, one with aggregation one without. Only one Idea except that I have is being sure that you have newest AppMon version. Second is checking if there is difference when you use classic or AppMon agents. The second one is build on top of OneAgent binaries used in dynatrace so it may work in different way than classic one.

Sebastian

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image Michael D. · Jan 21, 2020 at 07:05 PM 1
Share

We switched one of the agents to Classic, and that fixed the problem. I raised a ticket with support. Thanks!

avatar image

Answer by Chad T. · Jan 17, 2020 at 08:41 PM

@Andreas G. Andi might have some insight on this for you being that the original referenced Q&A was from 2015.
Comment
Chad T.

People who like this

1 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image

Answer by Michael D. · Jan 17, 2020 at 08:41 PM

Unfortunately not, we are looking at queries that are only executed once in the transaction. The purepath shows some miniscule number for the query, but drilling down to the database dashlet or right-clicking the query and viewing details shows a drastically different number.


Comment

People who like this

0 Show 2 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image Sebastian K. · Jan 17, 2020 at 09:06 PM 0
Share

Ok one more question, when you have aggregation disabled and query is presented as fast one, overall response time of this pure path is indeed 70s? If yes, did you tried using cpu sampling or show all nodes option to drill down about root cause then?

Sebastian

avatar image Michael D. Sebastian K. · Jan 17, 2020 at 09:20 PM 0
Share

Ask as many questions as you like, we could use any help!

If we disable aggregation, the query is presented with the correct response time.

No matter the aggregation setting, the purepath overall always shows the correct response time.

We know the root cause is the slow database query based on Node Details and the Drill down into the database dashlet. Our problem is getting the actual query response time to show up in the purepath with aggregation enabled.

Based on the 2015 forum post I linked, they were having the same problem with the DB Time measure fluctuating based on the aggregation setting. I haven't kept aggregation disabled long enough to see if this is the case for us, but seems like the same issue.

avatar image

Answer by Sebastian K. · Jan 17, 2020 at 08:37 PM

As I understand there is no chance that you have couple of hundreds of DB statement execution? In such case aggregation would indeed be result of sum. I’m wondering if in other case actually problem is with slow query. Maybe problem is with connection acquisition and during aggregation it’s summed up somehow. How your connection pools looks like?

Sebastian


Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

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

Related Questions

The state of the purepath is grayed

Is it possible to monitor Oracle databases via OEM (Oracle Enterprise Manager)

What is the correct measure that we need to use for seeing Database exceptions in Appmon?

Async thread invocation delay

in appmon is there a way break downwhich profiles/agents make up the "purepath status" in the Server Health dashboard.

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • 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