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 |
|
rosetulip
Starting Member
15 Posts |
 Posted - 2012-08-28 : 16:53:13
|
| I run SQL profiling to capture several messages like belowParallel query worker thread was involved in a deadlockOnce this error popped in profiling, it follows this pattenParallel query worker thread was involved in a deadlockinsert into ......(different)update.... from....(same1)update.... from....(same1)insert into ...... ( different )select ....(different)update.... from....(same2)update.... from....(same2)I don't understand this patten and error message. It seems the same update query run twice causing the deadlock, is it correct?Can someone give me more inside for this happening? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-08-28 : 16:57:17
|
| I'm not sure if I understand what you are saying, but if you are saying threads from a parallel query are deadlocking, then that is almost certainly a bug. Use MAXDOP=1 query hint.-Chad |
 |
|
|
|
|
|
SQL 2008 deadlock issue