Solved

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

Posted on 2009-03-31
4
303 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
[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
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
Learn about cloud computing and its benefits for small business owners.
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…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

740 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