Post reply

Multi Core Processors

  • February 6, 2007 at 3:54 am

    #62347

    We are looking at buying a new SQL Server for MI purposes and are looking at buying multi-core processors.

    Do you need to do enable any options in SQL Server to make use of the multiple-cores and do they still come under the per processor licensing model?

    Regards

     

    Carl

     

  • February 6, 2007 at 7:07 am

    #688015

    HI Carl,

    I think they come under the multi processor licensing model.

    Pete

    Peter Gadsby
    Business Intelligence Consultant
    www.hgconsult.co.uk

  • February 6, 2007 at 7:08 am

    #688016

    Multi cores work fine, licensing is per socket not per core. Some of the intel dual core also hyperthread so you see 4 cpu in task manager per socket. On an 8 way dual core this means you get to see 32 virtual cpu's ( inlcuding the HT )  Your license is for 8 cpu's.

    If your sql is less than optimal you may get issues with parallelism and possibly thread starvation - you may wish to limit sql server to the actual cores and ignore the HT. Only testing will show which way to go.

    I use dual core AMD and INTEL ( with HT ) , not fully evaluated the HT yet but the AMD boxes are fine.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 6, 2007 at 7:36 am

    #688027

    Thanks for the reply.

    Regards

     

    Carl

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

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