How to generate alert for Azure SQL DB

Question

How to generate alert for Azure SQL DB

Parekh, Ravi 0

Hi Team,

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

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

SSingh-MSFT 16,371 Reputation points Moderator

2023-10-25T04:56:32.21+00:00

Hi
Parekh, Ravi •,

Just checking if the provided reply is useful for your query.

Do let us know so that we can further assist you.

Thanks
Parekh, Ravi 0 Reputation points

2023-10-25T05:09:57.03+00:00

Hi Shakti, not yet, have added comments on the response. Thanks.

2 answers

Your answer

SSingh-MSFT 16,371 Reputation points Moderator

2023-10-25T04:56:32.21+00:00

Hi
Parekh, Ravi •,

Just checking if the provided reply is useful for your query.

Do let us know so that we can further assist you.

Thanks
Parekh, Ravi 0 Reputation points

2023-10-25T05:09:57.03+00:00

Hi Shakti, not yet, have added comments on the response. Thanks.

Answer 1

SSingh-MSFT 16,371 Moderator

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.

Parekh, Ravi 0 Reputation points

2023-10-25T05:09:23.9166667+00:00
Thank you for the reply, above one is for active session utlization, but I am looking forward for the help on below metrics, could you please suggest how these can be setup:

Query running longer than 1 hour (long running query)

Session running longer than 24 hours (long running session)

Table Space --> do we need to monitor table space utilization

I metric are not available, if any KQL is available or guidance on any Azure Monitor table providing such details will also help.

Thanks.
SSingh-MSFT 16,371 Reputation points Moderator

2023-10-25T05:30:04.16+00:00

Hi
Parekh, Ravi •,

Thanks for your reply.

Let me check on this internally and get back to you.

Answer 2

SSingh-MSFT 16,371 Moderator

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.

Parekh, Ravi 0 Reputation points

2023-11-01T04:50:47.0733333+00:00

Thanks Shakti, could you please share if there are any existing / recommended scripts available?

Also - is there a list of alerts which should be used as minimum monitoring for Azure SQL?

Thanks.
SSingh-MSFT 16,371 Reputation points Moderator

2023-11-08T04:24:43.7333333+00:00

Hi
Parekh, Ravi •

I would recommend you to please file a support ticket for such information and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks
Parekh, Ravi 0 Reputation points

2024-04-30T08:36:55.3866667+00:00

Thank you for the update, could you please suggest if it is worth to monitor table space similar to Oracle in this case and how? Else please suggest is each table space / schema space is managed here.

Share via

How to generate alert for Azure SQL DB

2 answers

Your answer