16 Dec 2022 11:59 AM - last edited on 19 Dec 2022 08:50 AM by MaciejNeumann
We have business requirement to create Anomaly detection or custom metric for monitoring the slow response of data base query/statement.
Please could you let me know how to create?
The end goal is, when the response time of particular DB statement is poor it requires alert and investigation.
Solved! Go to Solution.
16 Dec 2022 12:26 PM - edited 16 Dec 2022 12:27 PM
On the database service mark the specific statement as a Key Request.
Then you can set a static threshold for it in the service settings.
16 Dec 2022 12:58 PM
Thank you.
This works if we have any specific statement. But how we can configure if we don't have any specific DB statement rather, we would require monitoring all the database statements that breaches static thershold value?
16 Dec 2022 02:21 PM
Hi @Selvam_Sekar,
Please check this documnetation:
Best regards,
Mizső