There is not currently a built in alert for the metric 'avg. lock wait time' in SQL Monitor - please see the list of alerts.
You could make your own custom metric and alert querying the same dmv we do to gather the information - something like this perhaps:
SELECT cntr_value
FROM sys.dm_os_performance_counters
WHERE OBJECT_NAME = 'MSSQL$SQL2012:Locks'
AND counter_name = 'Average Wait Time (ms)'
AND instance_name = '_Total'
You should also go to the SQL Monitor Uservoice and raise a suggestion for including alerts for other metrics or vote on one if it already exists.
dj_annie
Posts: 1 New member
Answers
There is not currently a built in alert for the metric 'avg. lock wait time' in SQL Monitor - please see the list of alerts.
You could make your own custom metric and alert querying the same dmv we do to gather the information - something like this perhaps:
You should also go to the SQL Monitor Uservoice and raise a suggestion for including alerts for other metrics or vote on one if it already exists.
Kind regards,
Alex
Have you visited our Help Center?