• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 684
  • Last Modified:

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?
0
sfotex
Asked:
sfotex
  • 2
1 Solution
 
Scott PletcherSenior DBACommented:
Verify that the "max degree of parallelism" option, shown/set via sp_configure, is set to a value > 1.
0
 
Scott PletcherSenior DBACommented:
Or to 0, of course.
0
 
kaufCommented:
Additionally you can set SQL which CPU's to use (check some, one or all in the settings box)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now