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

[Anonymous]

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.

[Saradhi.Potharaju]

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]

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