02 Dec 2018
10:53 PM
- last edited on
09 Dec 2021
11:08 PM
by
MaciejNeumann
May i ask abnout SaaS & Managed\
As far as i get it :
- shows who call DB
- shows expeensive calls and queries
As stated at https://www.dynatrace.com/capabilities/database-monitoring/
Question is
Does it provides any tips or sugestions on how to improve those SQL queries?
Regards,
Igor
Solved! Go to Solution.
Hi Igor,
I assume that you haven’t used Dynatrace yet... In Dynatrace you can see the exact statement that is used to execute a query/modification, and in the context of the transaction. Hence you can see someone clicking a button and from there you can drill down to the individual sql statements for that specific user action.
Dynatrace does not offer a “replace this statement with this better statement” kind of function.
What I often do, is look at the troublesome statements (long running) and cut ‘n paste them to check in the (e.g. Oracle) client what the execution plan looks like. Based on that you (or the DBA) can help optimize the sql.
So no magical new statement generation, just a very accurate contextual view on the usage of your database.
Hope this helps.
Cheers,
Sjoerd
Hello Sjoerd.
Yes sure i am oly started to explore SaaS and managed. I have it in 15 day evaluation.
Thank you for helping me! It is much clearer now.
Regatrds, Igor