question

vamshi k. avatar image
vamshi k. asked ·

In purepaths I see more time is consumed in socketRead0 can you please help me to understand the issue better?

Here is the session attached

socketrread0.dts

I am running a jee application on Websphere application server.

If you see the transaction flow nothing is shown in red also transaction response time contribution of database is (0.03%)very less.

Execution time of queries is also very very less.

But the socketRead0 alone took all the respone time which is 21921.28ms

What could be the issue?

Does the scoketRead0 here intdicates data being fetched to the application over the network.

Could you pleae analyze the purepaths and help me understand the issue better?

appmonjavadatabasepurepath
socketrread0.dts (11.5 MiB)
10 |2000000 characters needed characters left characters exceeded

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

Harald B. avatar image
Harald B. answered ·

Hi,

The time is consumed by ResultSet.next() calls which are not instrumented by default. That is why the transaction flow shows different numbers.

Best

Harry

Share
10 |2000000 characters needed characters left characters exceeded

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

Joe H. avatar image
Joe H. answered ·

Vamshi,

In addition to what Harry said, keep in mind that Socket.read is a low level java function. It's best to look up the stack and search for the context of what's calling socket.read. In this situation (as identified by Harry), it's a JDBC call to ResultSet.next.

This can happen if the result set is excessively large, and/or if the database is slow and/or the network might be slow. Perhaps take a look at the associated JDBC Execute and inspect the number of rows returned.

But either way, you now know where your transaction is spending most of it's time.

hth

joe hoffman

Share
10 |2000000 characters needed characters left characters exceeded

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

Space Topics

mobile monitoring dotnet synthetic monitoring reports iis chat kubernetes servicenow amazon web services mysql mainframe rest api errors cassandra dashboard oneagent sdk cmc application monitoring openkit smartscape request attributes monitoring developer community user tagging log monitoring services ufo syntheticadvisory activegate ip addresses auto-detection high five award oracle hyperion webserver uem usql iib test automation license web performance monitoring ios news migration management zones index ibm mq web services custom event alerts notifications sso host monitoring knowledge sharing reports browser monitors java hybris sap vmware maintenance window user action naming javascript appmon ai synthetic classic availability tipstricks automation extensions diagnostic tools session replay permissions davis assistant faq documentation problem detection http monitors server easytravel apdex aws-quickstart network docker tags and metadata cloud foundry google cloud platform synthetic monitoring process groups account usability dynatrace saas gui paas openshift key user actions administration user actions postgresql synthetic locations oneagent security Dynatrace Managed user management custom python technologies mongodb openstack user session monitoring continuous delivery citrix configuration alerting NGINX action naming linux nam installation masking error reporting database mission control jmeter recorder apache mobileapp RUM php threshold azure purepath davis scripting agent aix nodejs android