question

SinghVikram-6773 avatar image
0 Votes"
SinghVikram-6773 asked AnuragSharma-MSFT commented

Metric for monitoring blocked sessions

We have a requirement to monitor blocked sessions on a database but do not have the right metric which can be used.
We did try the blocked processes metric but that is giving the blocked processes count at a point in time, not exactly what we need.
The database team needs an alert to be fired when a database or a database server has a blocked process persisting for more than 15 mins.
Please let me know if there is a metric which can help us achieve this monitoring.

azure-sql-databaseazure-monitor
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SinghVikram-6773, welcome to Microsoft Q&A forum.

By blocking session, do you mean to say if multiple sessions are trying to access the same locked object? Also if possible, please provide the screenshot of blocked processes metric as well. Thanks.

0 Votes 0 ·

0 Answers