Does anyone know of a script to use for an alert in sql 2008 standard for Extreme Deadlocks (blocking). Only this type of alert.
I have the use of quest tools, spotlight in particular. But I need to be proactive I need to send an alert for extreme locks causing blocking to our helpdesk.
Does anyone have any advice? or a script i can create. Thanks in advance.