topic Re: Dynatrace Alerting on SQL blocking event in Alerting

Dynatrace Alerting on SQL blocking event

harshk0602 — Wed, 20 Aug 2025 06:02:58 GMT

Can we alert in Dynatrace based on the following conditions

no new SQL modifications after at least 5 minutes may indicate a blocker on the database.
Any other way to alert when there is SQL Blocking event occurrence.

Re: Dynatrace Alerting on SQL blocking event

Mizső — Wed, 20 Aug 2025 08:57:56 GMT

You can create calculated service metrics (with proper filter because there is a limitations for 100 database services). Maybe with management zones. For the calculated service metrics you can setup metric events.

I hope it helps.

Best regards,

János

Re: Dynatrace Alerting on SQL blocking event

harshk0602 — Thu, 21 Aug 2025 19:33:49 GMT

Thank you @Mizső for quick response. I am able to get the request count, can we also know the if any of SQL modification request taking longer time say for example more than 5 minutes.

Re: Dynatrace Alerting on SQL blocking event

dannemca — Thu, 21 Aug 2025 19:51:53 GMT

Just need to replace the request count metric for response time.

Re: Dynatrace Alerting on SQL blocking event

Mizső — Thu, 21 Aug 2025 22:24:33 GMT

@harshk0602

OR you can create a brand new custom metric just extend the MDA with a response time filter. This will count the database transaction with response time >= 5min.

Best regards,

János

Re: Dynatrace Alerting on SQL blocking event

harshk0602 — Thu, 04 Sep 2025 17:07:21 GMT

Thank you @Mizső for quick turnaround! I have configured it.