alert for metric avg. lock wait time

Answers

• Alex B Redgate › Posts: 1,157 Diamond 4

  March 6, 2018 8:44PM

  Hi @dj_annie,
  
  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.
  
  Kind regards,
  Alex

  Product Support Engineer | Redgate Software
  
  Have you visited our Help Center?

  0 · Share on Twitter