topic Re: Alert Notification for Excessive Database Instructions in Specific Requests in Alerting

Alert Notification for Excessive Database Instructions in Specific Requests

istvan_safranek — Wed, 07 May 2025 06:32:47 GMT

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

Re: Alert Notification for Excessive Database Instructions in Specific Requests

ChadTurner — Wed, 07 May 2025 17:46:03 GMT

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.

Re: Alert Notification for Excessive Database Instructions in Specific Requests

istvan_safranek — Thu, 08 May 2025 06:22:07 GMT

Hi Chad,

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

Re: Alert Notification for Excessive Database Instructions in Specific Requests

ChadTurner — Thu, 08 May 2025 11:46:01 GMT

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.

Re: Alert Notification for Excessive Database Instructions in Specific Requests

Yosi_Neuman — Fri, 09 May 2025 08:42:41 GMT

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

Re: Alert Notification for Excessive Database Instructions in Specific Requests

istvan_safranek — Thu, 29 May 2025 13:58:38 GMT

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!