cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Health Rule creation for slow response DB statement

Selvam_Sekar
Participant

We have business requirement to create Anomaly detection or custom metric for monitoring the slow response of data base query/statement.

Please could you let me know how to create?

The end goal is, when the response time of particular DB statement is poor it requires alert and investigation.

 

 

3 REPLIES 3

pahofmann
DynaMight Guru
DynaMight Guru

On the database service mark the specific statement as a Key Request. 

Then you can set a static threshold for it in the service settings.

Dynatrace Certified Master, AppMon Certified Master - Dynatrace Partner - 360Performance.net

Selvam_Sekar
Participant

Thank you. 

This works if we have any specific statement. But how we can configure if we don't have any specific DB statement rather, we would require monitoring all the database statements that breaches static thershold value?

Mizső
DynaMight Leader
DynaMight Leader

Hi @Selvam_Sekar,

Please check this documnetation:

https://www.dynatrace.com/support/help/shortlink/problem-detection-sensitivity-database-services#res...

Best regards,

Mizső

Certified Dynatrace Associate