Is there a way I can monitor slow queries on the database and discover which code originated this slow query?
I can see some queries on the Database section and get some information from PurePath on Transactions and Services, but I can't seem to find a way to know where the query was generated, like a complete stacktrace that shows which files (and which line) generated this query (I'm running a PHP application).
Is it possible to discover that with Dynatrace?
Solved! Go to Solution.
This should be possible by performing a "Service Backtrace" within Dynatrace. See more on that here: https://www.dynatrace.com/support/help/shortlink/service-backtrace and here: https://www.dynatrace.com/support/help/shortlink/database-services#database-service-backtrace
More on how Dynatrace detects the database activity here: https://www.dynatrace.com/support/help/shortlink/database-detection
As your question relates to our Dynatrace SaaS and Managed offerings, I'll move this question to the appropriate forum. (Because "AppMon & UEM Q&A" relates to one of our classic products.)
Actually, you can do something similar, wont give you the exact line of code, but you can see purepath:
or an overall of all the calls and add a filter for calls to an specific DB and specific response time:
From there you can see the callstack or even download the source. The only thing that wont showup is the code line i think.