cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Is it possible to determine what method or code object executed SQL Query

jodom
Explorer

I'm trying to determine if it's possible to trace a query listed on the Database Queries Window back to the calling method? I can see the servers the query was executed by but can't figure out how to trace back from there to determine what method/object is making the call.

2 REPLIES 2

Saradhi.Potharaju
AppDynamics Team (Retired)

Hi,

 

Currently this is not possible. If a business transaction executes a query that can be seen in the transaction snapshot and that backend can be viewed in database if a collector is configured but the reverse of tracking a business transaction (calling method) from a query is currently not possible.

 

PS: If this answer helped you or answered your question, please click Accept Solution below.

 

Regards,

Saradhi

Cansel.OZCAN
Maker

Hi,

 

Is this possible after 4.5.1 version with java application and also after 4.5.4.xx you can determine with .NET application too.

 

https://docs.appdynamics.com/display/PRO45/Database+Business+Transactions+Window

 

Thanks

Cansel