|
rosetulip
Starting Member
4 Posts |
 Posted - 08/28/2012 : 16:53:13
|
I run SQL profiling to capture several messages like below
Parallel query worker thread was involved in a deadlock
Once this error popped in profiling, it follows this patten
Parallel query worker thread was involved in a deadlock
insert 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? |
|
SQL 2008 deadlock issue
