Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2009-03-31
4
Medium Priority
?
318 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 1000 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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). …
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…
Suggested Courses

661 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