Server Environment:
- Windows 2003 Standard R2 x64 SP2
- SQL 2005 Enterprise 64-bit SP2
- HP ProLiant BL460c G1, Xeon E5440 2.83 Ghz processors (Quad-core)
- 8 GB RAM
EDIT: I should also note that max_workers_count is currently at the default 512 for a 4 processor box
We're running into threadpool deadlocks that I'm fairly sure are the related to parallelism. The deadlock graphs are nearly identical to those in Bart Duncan's post about Intra-Query Parallel Thread Deadlocks, and I don't see any mention of lock resources in the deadlock output, as mentioned in the Caveats section of his post which is what leads me to believe this is a parallelism thing.
I'm in the process of tuning the queries that look to be related to these, but this will take a little while (read "a couple of weeks"). In the meantime, I am wondering if upping the threadpool would be wise or not as a temporary workaround.
Any SQL Jocks out there want to help a guy out?
(BTW - going to SP3 is not an option right now because of this problem)