Solved

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

Posted on 2009-03-31
4
288 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

Are your corporate email signatures appalling?

Is it scary how unprofessional your email signatures look? Do users create their own terrible designs and give themselves stupid job titles? You can make this a lot easier for yourself by choosing an email signature management solution from Exclaimer today.

Question has a verified solution.

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

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found listed in my profile here: http:…
Learn about cloud computing and its benefits for small business owners.
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…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

863 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

20 Experts available now in Live!

Get 1:1 Help Now