Hi, Can we change the deadlock duration to notify and email the operators. I am getting lot of deadlock email alerts every 2 mins as the vendor code is not that good and the deadlocks disappear in 5 to 10 secs by the time i check. I am looking for the deadlock notification email or alerts sent only if the deadlock stays there for more than 20 secs. Snaphot isolation level, code etc checked. Thanks
Deadlocks don't have a duration and would not 'disappear' if given more time.. Deadlocks are events that are caused by a situation when 2 or more processes are blocking each other in such a way that will never resolve, so the Deadlock Monitor thread looks for these occurrences, resolves by killing one of the processes, and raises the alerts. Do you mean blocking? If so - what mechanism are you using to monitor and email?