Post reply

SQL 2005 Standard with multiple cpu's

  • February 25, 2008 at 10:28 am

    #203670

    Assuming that SQL Server 2005 standard can only use 4 cpu's (correct?),

    if we purchace a server with 2 sockets, quad core, will there be any issues setting it up so SQL will use 2 cores on 1 socket and 2 core on the other?

    Or will SQL just grab the 1st 4 cores?

    Thanks...

    Marc

  • February 25, 2008 at 11:07 am

    #781673

    SQL server licensing is per socket - i.e. 2 sockets, 2 cores you only have to license the 2 sockets. SQL server will make use of all (4) logical CPU(s).

    For more information, reference:

    http://www.microsoft.com/sql/howtobuy/multicore.mspx

    Tommy

    Follow @sqlscribe

  • February 25, 2008 at 11:32 am

    #781681

    Thanks for the answer, but I think you missed my point.

    I'm not asking about licensing, I'm asking about configruing a server with 2 socekts / quad core (IE SQL sees 8 CPU's).

    Background:

    I asked a vendor to quote me a server with 2 sockets, dual core, but he sent me 2 sockets quad cores... hence my question...

    Thanks...

    Marc

  • February 25, 2008 at 11:40 am

    #781686

    SQL Server considers the number of sockets, regardless of the number of cores on the processor. In your case, standard will see all 8 logical processors and you only have to license for 2 sockets, an added bonus 😀

    Tommy

    Follow @sqlscribe

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply