Deadlock Detection on MS SQL 2008

Is it possible to detect deadlock on SQL 2008 and send out an email alert ?

Tks
AXISHKAsked:
Who is Participating?
 
Vadim RappCommented:
Enabling Email Alerts for SQL Server Deadlocks
by Michael K. Campbell in Practical SQL Server
0
 
AXISHKAuthor Commented:
Which window counters can indicate deadlock?
0
 
Vadim RappCommented:
Number of deadlocks / sec, in performance object "Locks".
0
 
AXISHKAuthor Commented:
Tks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.