topic Re: DataBase Monitoring in Open Q&A

DataBase Monitoring

DAVID_MTZ — Thu, 05 Sep 2024 09:58:06 GMT

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?

Re: DataBase Monitoring

p_devulapalli — Thu, 05 Sep 2024 01:50:45 GMT

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

Re: DataBase Monitoring

DAVID_MTZ — Fri, 06 Sep 2024 00:35:24 GMT

Hi p_devulapalli, thank you very much for the help.

Best regard.