MY SQL server kept dumping threads and locking up. After a call to MS we changed a 0 to a 1 and the issue went away. CPU usage went form 100% to about 35%
The setting is MAXDOP. Apparently if it is set to 0 SQL executes queries across all processors in parallel. When it gets a block, it blocks all processors. Setting it to 1 makes it run 1 query on 1 processor allowing up to 8 queries to run at once. The SQL guy said he saw many cases of this nature in the SCCM queue. It is not in the documentation or any TechNet article or MS KB ... Grrrrrrrr. This is what we changed. I am in no way advocating this, just an FYI. I had never heard of it before.
