Solved

Using all processor cores with WS 2003 Standard x64 and SQL Server

Posted on 2009-03-31
4
292 Views
Last Modified: 2012-05-06
We have the same OS, same application and same SQL Server running on 2 very simlar machines:
Windows Server 2003 R2 x64
MS SQL Server 2005 Standard x64
Dell PowerEdge 2900 (differ in number of processors)
On PE2900 with 2 dual-core processors (4 cores) SQL Server uses all 4 cores
On PE2900 with 4 dual-core processors (8 cores) SQL Server uses ONLY 2 CORES!
Can anyone tell why and how to make the latter use all 8 cores?
0
Comment
Question by:Alex-U
  • 3
4 Comments
 
LVL 11

Expert Comment

by:Abhay Pujari
ID: 24027808
Probably this would be the answer to your question http://msdn.microsoft.com/en-us/library/ms143760.aspx
0
 
LVL 11

Expert Comment

by:Abhay Pujari
ID: 24027821
The above post is for SQL 2008. See this for SQL 2005 http://msdn.microsoft.com/en-us/library/ms143760(SQL.90).aspx.
0
 

Author Comment

by:Alex-U
ID: 24027863
Thank you, but why do you think it is 4 cores, not 4 sockets as for operating system?
0
 
LVL 11

Accepted Solution

by:
Abhay Pujari earned 250 total points
ID: 24027897
SQL server treats Virtual sockets as Cores and not sockets. That is why you can see only on 4 processors (8 cores), you can see only 2 (2x2).
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

This is a little timesaver I have been using for setting up Microsoft Small Business Server (SBS) in the simplest possible way. It may not be appropriate for every customer. However, when you get a situation where the person who owns the server is i…
Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

777 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