We have a database running with about 40 users per branch (6 branches). The replication we are running at the moment (MERGE) often causes our systems to deadlock, upon which the only way to fix it is to kill the BLOCKING process.

I would like to set up an alert that can notify me when a deadlock occurs, but so far the only success i have is on a normal lock - which occus hundreds of times per second.

If anyone can help me out it will be of great help. My e-mail address is it@bex.co.za

Thanx,
Neil

RE: From EM:
(Expand out to Alerts)
Sql Server Instance:
Management:
Alerts:

(right click Alerts, select)--> New Alert:
Name: [Deadlocks/sec]
Type: (select from dropdown)--> Sql Server Performance conditon alert
Object: (select from dropdown)--> YourInstanceName:Locks
Counter: (select from dropdown)--> Number of Deadlocks/sec

Alert if counter: (select from dropdown)--> rises above
Value: [0]