• 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 Paul S. · Feb 20, 2014 at 04:25 PM ·

Hibernate persistOnFlush over 100000 Events in dynaTrace

Hello Guys,

 

I have with dynaTrce 5.6 the problem that some pure paths get cut because dynaTrace captures thousands of hibernate flush events. Has anybody already a solution for this?

 

Thanks,

 

Paul

 

Web_Requests_Dashboard_-_dynaTrace_Client-2.png

Comment

People who like this

0 Show 0
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.

4 Replies

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

Answer by Paul S. · Feb 20, 2014 at 05:02 PM

Yeah that makes sense to me. Basically I want to know how many objects are currently attached / loaded. As I see only one "select". The problem is that one an the same value is written 25145 times (still increasing) into the "n" table.

 

Basically Book --> ISBN. Isbn is always added on a update, even if it is the same. Does not look bad in the SQL. One simple insert statement. But it grows over time and usage.

If this book is now loaded, it contains a lot of ISBNs â€“ having the save value. I discovered it as I have seen that the response is very large, more then 1MB of a simple book record is a little to much (smile).

 

Does this make sense?

Comment

People who like this

0 Show 3 · 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 Andreas G. ♦ · Feb 20, 2014 at 05:09 PM 0
Share

makes sense. Would you be wiling to share PurePaths with me of this? Maybe even a "Before" and "After-the-fix" PurePath? I am always looking for these "data driven" problem pattern examples

avatar image Paul S. Andreas G. ♦ · Feb 20, 2014 at 05:12 PM 0
Share

I yes, the management I guess not â€“ as the code can be decompiled if I upload the pure paths (sad).

avatar image Andreas G. ♦ Paul S. · Feb 20, 2014 at 05:15 PM 0
Share

Exported PurePaths DO NOT contain the byte code. The decompile feature only works on your live System Profile. So - should not be a problem. Also - you can send it to me directly via email (firstname.lastname@compuware.com) in case you dont want to share it with a larger public

avatar image

Answer by Paul S. · Feb 20, 2014 at 04:48 PM

Okay I removed it and the problem is gone BUT, (where is always a BUT) actually it pointed out a software bug. I digged deeper into the code â€“ and tada the developer did an error:

 

A 1 : n relation table is growing "out of limits"

 

the only point where this is now is visible is the "io write" as it is a remote call. Not sure if I really want to remove it then?

 

Is were a way to monitor large Hibernate sessions, with to many objects attached to it?

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 Andreas G. ♦ · Feb 20, 2014 at 04:56 PM 0
Share

Database access should be captured with our JDBC Sensor. Looking at these PurePaths you can drill to the database dashlet and you should see the statements executed. Will this help identify the problem?

If not - which Hibernate Method did you look at to find this problem? You may just want to add a custom sensor for that method that allows you to see this pattern - but exclude (=not place) the Hibernate Sensor Pack in general

avatar image

Answer by Andreas G. · Feb 20, 2014 at 04:35 PM

It comes with dynaTrace - but - starting with dynaTrace 5.x we do not automatically "place" it for new System PRofiles. We also recommend to unplace this Sensor Pack as Auto Sensors are doing a great job to capture Hibnerate performance problems

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.

avatar image

Answer by Andreas G. · Feb 20, 2014 at 04:29 PM

The solution is to disable the Hibernate Sensor. With new System Profiles we actually dont activate this Sensor Pack any longer as our Auto Sensors will pickup slow Hibernate calls for you anyway without "filling" your PurePath with lots of these nodes


 

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 Paul S. · Feb 20, 2014 at 04:33 PM 0
Share

Is this not a build in sensor pack in dynaTrace?

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

1 Person is following this question.

avatar image

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