Monitoring of SQL Server hosted in virtual machines

Tochukwu Ezeokoli 1

Is it possible to create Azure alerts to monitor SQL servers on virtual machines for metrics like deadlocks ?

1 answer

Leon Laude 86,086 Reputation points

2020-07-14T16:08:47.197+00:00

Hi,

Yes this should be possible, there is an Azure Monitor metric specifically for deadlocks:

You'll find the list of metrics here:
https://learn.microsoft.com/en-us/azure/azure-monitor/platform/metrics-supported

Best regards,
Leon
Please sign in to rate this answer.

1 person found this answer helpful.
Tochukwu Ezeokoli 1 Reputation point

2020-07-15T12:15:59.04+00:00

Hey Leon,

Thanks for the link provided. However, this applies to Azure SQL databases (Database as a Service). My goal here is to create an alert for deadlocks on a VM which hosts an SQL server.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer