Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2010-06-03 : 22:40:41
|
| hi everyone,In my 2005 database, I have configured an Alert for error 1205 (Transaction Deadlock). Several deadlocks occurred today but I did not receive the email. In fact, when I view the Alert info, it shows that 0 alerts have occurred.Facts: I HAVE received emails for other kinds of alerts on this server. I DO know that the agent email is working.Do I need to configure something else to enable the deadlock alert to work properly?Thanks, John |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-06-04 : 13:58:02
|
| ... some more info. I checked the SQL Server log and deadlocks are not being written to the Log. So I then ran DBCC TRACEON(1222, -1) which (I think) forces deadlocks to be logged into the log. Maybe that will enable the Alert to notify me when a deadlock occurs.Does any one if I have to bounce MSSQL to get the trace in effect?Thanks, John |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-06-06 : 17:20:51
|
| after turning on Trace flag 1222, I'm still not receiving alerts for deadlocks. I now have 2 flags on 1204 and 1222. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Deadlock Alert not Working