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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-11-22 : 12:49:30
|
| Hi Is there any way to Identify a Deadlock using the Enterprise Manager.Someone told me that the Red Icon on the Lock/Process ID (Spid) mean a Dealock ... is that True ??? |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-22 : 13:09:14
|
| Just look at the last two columns of the Process Info, if there are two processes that are blocked by each other that's a potential deadlock. Deadlocks are automatically detected and one of the connections transactions automatically rolled back though so you'll struggle to see it in EM because you have to refresh the Current Activity view at the exact moment of the deadlock.You'll need to monitor with Performance Monitor or SQL Profiler if you want to track the deadlocks more reliably. |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-11-23 : 18:36:23
|
| > Someone told me that the Red Icon on the Lock/Process ID (Spid) mean a Dealock ... is that True ???That is not true. It's one process blocking the other, which is not uncommon.Blocking processes can potentially lead to deadlocks.But deadlocks will only occur if processes block each other in a "circular fashion",so that one has to be "killed" in order to resolve the blocking situation.rockmoose |
|
|
|
|
|
|
Deadlock Identifying