alert not triggering on azure sql

Surapally Sravan Kumar 0

Hi , we configured alert rule for static ,aggregation type average, greater then , threshold 40% on sql db ealier alerts was worked last few days not working this prod db we are facing lot of issue unless see the metrics then we know the cpu status please look into this issue

NIKHILA NETHIKUNTA 3,925 Reputation points Microsoft Vendor

2024-12-18T15:35:10.6033333+00:00

@Surapally Sravan Kumar
Thank you for the question and for using Microsoft Q&A platform.
Can you please provide me with more information about the problem you're facing?

Which monitoring tool are you using to configure the alert rule? Also, can you please confirm if the alert rule is still active and enabled?
Once I have more information, I can help you troubleshoot the issue and find a solution.
Surapally Sravan Kumar 0 Reputation points

2024-12-19T04:45:11.2766667+00:00

@NIKHILA NETHIKUNTA we using azure monitor , azure alert rules are configured and tested action group am able receive test email ,alert rules are enabled we troubleshooted the alert rules however it not working kindly guide us on priority basis
NIKHILA NETHIKUNTA 3,925 Reputation points Microsoft Vendor

2024-12-19T18:25:51.8966667+00:00
@Surapally Sravan Kumar
Thank you for the details.

As per my understanding you are experiencing issues with your Azure Monitor alert rules for your SQL database.

Here are a few steps and considerations to help troubleshoot and resolve the issue:

Check that Aggregation type and Aggregation granularity (Period) are configured as expected.

Check that Threshold value or Sensitivity are configured as expected.

For an alert rule that uses Dynamic Thresholds, check if advanced settings are configured.

Check if there's already a fired alert on the metric time series for which you expected to get an alert.

Check the aggregation and time granularity. The selected Aggregation in the metric chart is the same as Aggregation type in your alert rule.

If you created the alert rule in the Azure portal, clear the Automatically resolve alerts option under the Alert rule details section. The frequency of notifications for stateless metric alerts differs based on the alert rule's configured frequency.

Check the metric data: Ensure that the monitored metric (e.g., CPU usage, DTU, etc.) is actually exceeding the threshold you configured in the alert rule.

For more information, please refer to the below links:
https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-troubleshoot#i-didnt-receive-the-expected-email
https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-troubleshoot-metric
https://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-metrics-alerts?view=azuresql
https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-dynamic-thresholds

Hope this helps. Please let us know if you have any further questions.
SHABBIR SHAIK 0 Reputation points

2024-12-19T19:37:11.59+00:00
If your Azure SQL alert is not triggering, try these steps:

Verify Alert Configuration: Ensure the alert rule is set for the correct metric (CPU usage), aggregation type (average), and threshold (40%).

Check Metric Values: Ensure CPU usage is crossing the 40% threshold. If it's consistently below, no alert will trigger.

Alert Evaluation Period: Make sure the evaluation period is set appropriately, as short spikes might not trigger an alert.

Action Group: Confirm that the action group is properly configured and that notifications (email, SMS, etc.) are enabled.

Azure Service Status: Check if there are any ongoing issues with Azure monitoring or alerting services.

Test Alerts: Adjust thresholds or aggregation types temporarily to test if the alert triggers under different conditions. 7. Review Metrics Data: Ensure CPU metrics are being accurately recorded without gaps.
SHABBIR SHAIK 0 Reputation points

2024-12-19T19:38:30.1533333+00:00
If your Azure SQL alert is not triggering, try these steps:

Verify Alert Configuration: Ensure the alert rule is set for the correct metric (CPU usage), aggregation type (average), and threshold (40%).

Check Metric Values: Ensure CPU usage is crossing the 40% threshold. If it's consistently below, no alert will trigger.

Alert Evaluation Period: Make sure the evaluation period is set appropriately, as short spikes might not trigger an alert.

Action Group: Confirm that the action group is properly configured and that notifications (email, SMS, etc.) are enabled.

Azure Service Status: Check if there are any ongoing issues with Azure monitoring or alerting services.

Test Alerts: Adjust thresholds or aggregation types temporarily to test if the alert triggers under different conditions.

Review Metrics Data: Ensure CPU metrics are being accurately recorded without gaps.
NIKHILA NETHIKUNTA 3,925 Reputation points Microsoft Vendor

2024-12-23T17:53:47.4466667+00:00

@Surapally Sravan Kumar
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
NIKHILA NETHIKUNTA 3,925 Reputation points Microsoft Vendor

2024-12-25T17:43:26.5+00:00

@Surapally Sravan Kumar We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

alert not triggering on azure sql

Your answer