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

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?
Alex-UAsked:
Who is Participating?
 
Abhay PujariCommented:
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
 
Abhay PujariCommented:
Probably this would be the answer to your question http://msdn.microsoft.com/en-us/library/ms143760.aspx
0
 
Abhay PujariCommented:
The above post is for SQL 2008. See this for SQL 2005 http://msdn.microsoft.com/en-us/library/ms143760(SQL.90).aspx.
0
 
Alex-UAuthor Commented:
Thank you, but why do you think it is 4 cores, not 4 sockets as for operating system?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.