Share via

Alerts SQL Data Bases

Fernando Gutierrez 325 Reputation points
2023-10-17T12:25:40.87+00:00

Hi there

I need to make a query regarding the configuration of alerts in the SQL databases in Azure.

Within the alert configuration, in the "condition" option, how can I configure it to activate the alert not when it barely reaches the indicated %, but when it remains at that percentage for a few minutes? .

Since many times the databases when they receive the "query" reach that % of CPU indicated, but it immediately drops, in those cases, I would not like to activate the alert, but rather activate it when it remains at that % for a period of time. time.

Thanks!

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
    2023-10-17T19:08:19.5066667+00:00

    Hi, @Fernando Gutierrez Thanks for posting your question in the Microsoft Q&A forum.

    I understand your concern about activating alerts when the databases reach a certain percentage of CPU usage and then immediately drop.

    To configure alerts in Azure SQL databases, you can follow the instructions provided in the Azure documentation https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-alerts?view=azuresql

    Regards

    Geetha

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.