Email sp_who2 on lock/wait sql server 2008
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 23, 2010 9:10 PM
UPDATED:
April 15, 2011 1:14 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
same issue here, alerts not firing until after the lock clears…