• 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.