Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server multi-processor question

Posted on 2003-11-13
3
Medium Priority
?
679 Views
Last Modified: 2012-06-22
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
Comment
Question by:sfotex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 9742087
Verify that the "max degree of parallelism" option, shown/set via sp_configure, is set to a value > 1.
0
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 500 total points
ID: 9742091
Or to 0, of course.
0
 

Expert Comment

by:kauf
ID: 9744045
Additionally you can set SQL which CPU's to use (check some, one or all in the settings box)
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question