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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-03 : 13:06:54
|
| Sameer writes "Can anyone help me resolve deadlock with following text from profiler :Parallel query worker thread was involved in a deadlockI have checked the spid involved i.e the blocking one and the victim. Select statement is blocked and is deadlock victim toupdate and insert from stored procedure.I check the query and was hard to find anything having long blockage or lock. Queries were running allright for long and allof sudden in last week to many deadlocks with same textdata.I am finding difficult to understand what is this parallel worker thread involved suggests,and work around to it.I am using sql200 with latest service pack.Thanks in advance for any knowledge share.Sameer Raval" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-03 : 22:22:25
|
| Queries don't have to be long running to cause deadlocks.Sounds like your data has increased to cause the optimiser to choose a plan which is deadlocking.Without knowing more about your system it's difficult to guess what is happenning but any select with an aggregate is a possible cause.Limiting the server to one cpu or putting withh maxdop = 1 may help as it will stop parallel execution plans.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DeadLock