database monitoring - are there tips on how to improve SQL queries

[imoskovko1]

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/

• Auto-detect your databases
• See how applications use your databases
• Get detailed metrics for each database statement

Question is

Does it provides any tips or sugestions on how to improve those SQL queries?

Regards,

Igor

[SjoerdB · Accepted 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

[imoskovko1]

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