Solved

SQL Server multi-processor question

Posted on 2003-11-13
3
672 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
  • 2
3 Comments
 
LVL 69

Expert Comment

by:ScottPletcher
Comment Utility
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:
ScottPletcher earned 125 total points
Comment Utility
Or to 0, of course.
0
 

Expert Comment

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

772 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now