topic database monitoring - are there tips on how to improve SQL queries in Open Q&A

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

imoskovko1 — Fri, 10 Dec 2021 07:08:20 GMT

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

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

SjoerdB — Mon, 03 Dec 2018 08:15:33 GMT

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

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

imoskovko1 — Mon, 03 Dec 2018 08:39:34 GMT

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