sfotex
asked on
SQL Server multi-processor question
I have a 4 proc system with SQL Server 2000 Standard edition running on Server 2000. When I run a query I only see one of the processors being utilized (50+%). The rest just sit idle. SQL server 2000 standard documentation says it supports 4 procs. I have SQL Server properties set to use all available procs. How do I get the rest of the processors to take some of the load?
Verify that the "max degree of parallelism" option, shown/set via sp_configure, is set to a value > 1.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Additionally you can set SQL which CPU's to use (check some, one or all in the settings box)