05 Sep 2024 01:59 AM - last edited on 05 Sep 2024 10:58 AM by MaciejNeumann
I have a question, im monitoring many SQL databases, i can see many information about databses how the statement or queries, about it, i can see the response time or failed request, but my question is, is possible see or know wich user is executing the statements, it from database monitoring module?
Solved! Go to Solution.
05 Sep 2024 02:50 AM
Dynatrace can find expensive database statements based on the service calls or user actions from which they originate but it does not directly show the specific user who executed a SQL statement. You can run a service backtrace to see the user interaction or service request that originated the SQL statement. This can help you understand the context in which the SQL statement was executed but does not provide individual user details at the level of specific SQL statement execution.
https://docs.dynatrace.com/docs/shortlink/top-database-statements#analyze-individual-sql-statements
06 Sep 2024 01:35 AM
Hi p_devulapalli, thank you very much for the help.
Best regard.