"Slow response time": problem root cause and recommendations

[agylpradipta]

Hello all,

Recently I got a problem detected and the root cause is for Database as attached below:

I know the green color means it is already solved. But actually I just restarted the database.

When I trace deep down, there is slow Execution problem as follows:

My question is, could Dynatrace give recommendation on what remediation I should do regarding that root cause?

Like maybe we should fix a certain query or maybe optimise some indexing regarding database.

Thank you in advance.

[Mohamed_Hamdy]

Hi agylpradipta,

Dynatrace will not give you a recommendation for that. however you will be able to see where is the issue easily, also, you can check the distributed traces to see what happened and the sequence of the executed queries, in your case maybe the issue is that the table is not indexed from the DB side and I might be wrong.

[Serak]

If dynatrace has the Database monitoring capability it could have solved many of this problem and break the silo between Database administrators and System Performance Teams, getting explain plan from the Db will show where the query is spending time , datadog has this capability  for MySQL, PostgreSQL and SQL Server