Share via

How to generate alert for Azure SQL DB

Parekh, Ravi 0 Reputation points
2023-10-20T04:17:07.59+00:00

Hi Team,

Could you please suggest how to generate an alert in below scenarios in Azure SQL via Azure Monitor?

  1. Query running longer than 1 hour (long running query)
  2. Session running longer than 24 hours (long running session)
  3. Table Space --> do we need to monitor table space utilization
Azure SQL Database

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee
    2023-10-20T06:17:07.6266667+00:00

    Hi
    Parekh, Ravi     •,

    Welcome to Microsoft Q&A forum.

    As we understand, you want to generate alerts for Azure SQL Database.

    Use Query Performance Insight for Azure SQL Database for queries analysis.

    For session use Sessions percentage signal mentioned here: https://learn.microsoft.com/en-us/azure/azure-sql/database/alerts-insights-configure-portal?view=azuresql

    User's image

    Refer to similar post https://learn.microsoft.com/en-us/answers/questions/165893/help-to-set-up-azure-alert-for-disk-space-alert-wh for Table Space alerts.

    Let us know if you have further queries.

    Thank you.

  2. ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee
    2023-10-27T04:49:53.4033333+00:00

    Hi
    Parekh, Ravi     •,

    Thanks for your patience.

    I have checked with the internal team and got below reply:

    Unfortunately, this is not an available capability in Azure Monitor alerts today.

    Customers can implement this themselves by using TSQL scripts querying DMVs, or by using OSS/third-party monitoring solutions.

    Microsoft recognizes the importance of in-depth monitoring and alerting for customer workloads in Azure SQL and is committed to providing a solution in the future.

    Hope this helps. Thanks for understanding.