I suspect there is a wrong semaphore (or similar multithreading control object) in MS-SQL that stops the processes and discredit the SMP.

Hello,

I have absolutely the same problem - 2-Xeon server (4 virtual CPU-s), MS-SQL 2000 Enterprise Edition, Win2000 Advanced Server... And all 4 CPU-s are used up to 30-35%. Even when different...