Archive

Reply
Moderator
Posts: 17
Registered: ‎02-09-2017

Re: CallGraph Snapshot Export Summary - JDBC Count

[ Edited ]

Hi Timo,

 

If the same JDBC SQL calls are recurring on continuous basis, we do not want to send it for each JDBC invocation, instead we maintain an index and show all those indexes referring to SQL calls. Glad that my request for PDF file made it clear to you even before i responded to it :)

Yes count is the number of rows fetched from those SQL calls. Can we close this case now :)


Thanks

Rajesh

New Contributor
Posts: 2
Registered: ‎03-13-2017

Re: CallGraph Snapshot Export Summary - JDBC Count

[ Edited ]

Hi, 

 

sorry for my delay. Sure, I can. 

 

The complete PDF has a size of 45MB. I greped out the important pages and found something interesting by my own. THANKS for having a look on it.

 

Details of the Call Graph:

 

2017-03-16 13_56_13-appdyn_understand_jdbc_tracing.docx - Word.png

 1st JDBC Call stack listed in the call graph

 

2017-03-16 13_56_36-appdyn_understand_jdbc_tracing.docx - Word.png

 

I checked the whole call graph export again and found something new for me. The [n] is a refferer / index for a specific SQL Call listed down in the document (my example is SQL query #3) 

 

2017-03-16 13_56_48-appdyn_understand_jdbc_tracing.docx - Word.png

 

A query summary is also listed in the document

 

 

2017-03-16 13_56_58-appdyn_understand_jdbc_tracing.docx - Word.png

 So, the "magic" behind the [3] is clear now. 

 

Last question to round everything up: The count value in my last screenshot is the number of rows / results sent by the database? 

 

If so, i am totaly fine now!

 

 

 

Timo

Moderator
Posts: 17
Registered: ‎02-09-2017

Re: CallGraph Snapshot Export Summary - JDBC Count

Hi Timo,

 

Could you please send us the exported PDF to provide you with more details.

 

Thanks

Rajesh

Community Manager
Posts: 49
Registered: ‎06-06-2016

Re: CallGraph Snapshot Export Summary - JDBC Count

Timo,

You can refer the explanation given in the below link

 

https://docs.appdynamics.com/display/PRO42/Call+Graphs#CallGraphs-JDBCandJDBCResultSetIterationinCal...

 

Regards,

Mohammed Rayan

Highlighted
New Contributor
Posts: 2
Registered: ‎03-13-2017
Accepted Solution

CallGraph Snapshot Export Summary - JDBC Count

Hi Community,

 

I am just looking for an explanation what this count means (see attachement) ? Is this the result set or how many calls are made?