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 |
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
 Posted - 2004-02-02 : 09:09:16
|
| I Ocassionaly get called out in the middle of the night for jobs falling over because of Deadlocks.I know that this can be prevented most of the time by adjusting our schedule, but in order for me to do this I need to know what processes caused the deadlocks.Is there a way of Identifying which were the Guilty Processes? |
|
|
MuadDBA
628 Posts |
Posted - 2004-02-02 : 10:50:38
|
| Look in the books online for TRACE flags....there is one of them you can set so that it delivers more information about the deadlocked processes and what they were doing when they were terminated. Hopefully that can help you. Combined with a SQL Profiler session, it should help you identify what is the cause. |
 |
|
|
|
|
|
Identifying which processes caused deadlocks.