June 20, 2005 at 1:27 pm
We're experiencing a large number of deadlocks since we began running SQL Server 2000 Enterprise Edition SP3 on a Dell 6650 with hyper threading intel processors. We don't have the same problem on Dell 6650's w/o the hyper threading. If I turn off the parallel query processing option the deadlocks stop. I've tried all of the suggestions from the Microsoft Knowledge Base under the following link -
http://support.microsoft.com/?kbid=837983
The only suggestion that actually yielded results was turning off parallel query processing but I don't want to give up what should be a performance advantage. Query tuning and index tuning hasn't helped. Any suggestions? I haven't applied SP4 yet. I'm wondering if anyone has seen the same problem resolved with SP4.
June 21, 2005 at 3:58 pm
We've turned off parallel processing on our OLTP systems during regular hours and enable it for nightly processing. Our report environment has it on. It's a daily copy of the OLTP systems.
June 21, 2005 at 5:05 pm
Thanks for the reply, Mike. Did you turn it off in your OLTP environment because of deadlocks or some other performance consideration? Recently, I've tried limiting the number of processors available to parallelism. That seemed to help but didn't eliminate the problem completely. The QA group is telling me that the server seems faster now. I'm beginning to think that the answer is to just turn it off all together.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply