Dynatrace Alerting on SQL blocking event

[harshk0602]

Can we alert in Dynatrace based on the following conditions

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

[Mizső]

Hi @harshk0602 

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

[harshk0602]

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. 

[dannemca]

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

[Mizső]

@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