Alert Notification for Excessive Database Instructions in Specific Requests

[istvan_safranek]

Hello!
Is it possible to send an alert when the number of specific database statement in a specific request exceeds for example 20?

[ChadTurner]

I recommend taking at look at the extensions creator where you can create a DB query to look for that type of data. If you can report on that and provide a value, then you can create a Davis Anomaly Detector that will then trigger an alert based off the settings you provide. 

You just might need a DBA to help you with the query and the connection Creds. 

[istvan_safranek]

Hi Chad,

I forget to mention that I have dynatrace managed. Is this solution valid there?

[ChadTurner]

Correct, 99% of the functionality/settings is the same from Managed to SaaS. That 1% difference would be attributed to storage, retention values, backups etc on Managed which is configurable in the CMC since you own and provide the servers.

SaaS, since you dont own the servers, do not have the ability to configure those 1% of settings. 

[Yosi_Neuman]

Hi @istvan_safranek 

IMO you can focus on your desired database statement from Multi Dimensional Analysis  (AKA MDA) and create a calculate metric on it.

Then you can set a metric event on this calculated metric 

HTH

Yos