I have an alert set up to run a stored proc that will email me the results of a sp_who2 when the Lock Waits/sec rises above 2 seconds. The problem is that the alert doesn't fire off until after the lock has cleared, so the results of the sp_who2 are not very useful because they don't contain the lock information.
Is their any way to get this alert to fire during the lock instead of after?
March 23, 2010 9:10 PM
April 15, 2011 1:14 PM