Share via

Azure Synapse alert for Dedicated SQL Pool

Addy 0 Reputation points
2024-04-30T12:44:02.4566667+00:00

How can I properly set up an alert for a Dedicated SQL Pool in Azure Synapse for CPU Utilization? I want the alert to trigger if the CPU Utilization is more than 90% for an hour continuously. I have set the "check every" to 1 hour and "Lockback period" to 1 hour, and the aggregation type to average. Is this the correct setup?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,447 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vinodh247-1375 11,396 Reputation points
    2024-04-30T14:21:00.2133333+00:00

    Hi Addy,

    Thanks for reaching out to Microsoft Q&A.

    Follow the below link which explains step-by-step instructions of how to set this alert with all options explained. I can give you the steps or refer to another answer, but nothing beats this. Try to compare this with your implementation and let me know if you are able to validate successfully.

    https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/create-alerts-for-your-synapse-dedicated-sql-pool/ba-p/3773256

    Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

    1 person found this answer helpful.