Please anyone correct me if I am wrong.
I assume that you are using HypherThread since you are talking about logical CPU. Then, first, I'd like to know what is the O/S that you are using. This is from MSFT white paper about O/S.
| 2-way | 4-way | 8-way | |||
Windows Server Product | Physical | Logical | Physical | Logical | Physical | Logical |
Windows 2000 Server | 2 | 4 | 4 | 4 | n/a | n/a |
Windows 2000 Advanced Server | 2 | 4 | 4 | 8 | 8 | 8 |
Windows 2000 Datacenter Server | n/a | n/a | 4 | 8 | 8 | 16 |
Windows .NET Web Server | 2 | 4 | 2 | 4 | n/a | n/a |
Windows .NET Standard Server | 2 | 4 | 2 | 4 | n/a | n/a |
Windows .NET Enterprise Server | 2 | 4 | 4 | 8 | 8 | 16 |
Windows .NET Datacenter Server | n/a | n/a | 4 | 8 | 8 | 16 |
| 16-way | 24-way | 32-way | |||
| Physical | Logical | Physical | Logical | Physical | Logical |
Windows 2000 Server | n/a | n/a | n/a | n/a | n/a | n/a |
Windows 2000 Advanced Server | n/a | n/a | n/a | n/a | n/a | n/a |
Windows 2000 Datacenter Server | 16 | 32 | 24 | 24† | 32 | 32† |
Windows .NET Web Server | n/a | n/a | n/a | n/a | n/a | n/a |
Windows .NET Standard Server | n/a | n/a | n/a | n/a | n/a | n/a |
Windows .NET Enterprise Server | n/a | n/a | n/a | n/a | n/a | n/a |
Windows .NET Datacenter Server | 16 | 32 | 24 | 24† | 32 | 32† |
And then check it out this link.
http://www.microsoft.com/sql/evaluation/overview/default.asp
So if you have SQL Ent with Windows 2000 Advance Server or up, SQL server, that you will get the all 8 + 8 CPUs.
One thing that you need to know is that if you are using Windows 2000, you need to pay for 16 processors license and put 16 when you install sql but if you are using Windows 2003, just put 8 processors and purchase 8 CPU licenses only. O/S will know and read the Logical processors.
Any comments are welcome.