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 

[istvan_safranek]

Thank you for your response Yos!
However, I believe there might have been a misunderstanding. My question was specifically about triggering an alert when the number of a certain type of database statement within a single request exceeds a threshold (e.g., more than 20 times in one request).

The suggestion regarding Multi Dimensional Analysis and calculated metrics is appreciated, but it seems to focus more on aggregated data rather than per-request behavior.

Do you happen to know if there's a way to monitor and alert on this kind of per-request pattern?

Thanks again for your time!