UDB_Database_Lock_Warning

(Superseded) Issues a warning alert if the monitor database experiences certain conditions.

A warning alert is issued if the monitored database experiences one or more of the following conditions:
  • More than 10 deadlocks
  • More than 10 lock timeouts
  • More than 20 lock waits.
This situation has the following formula: 
deadlocks GT 10
or 
lock_timeouts GT 10
or 
lock_waits GT 20