Multi Core Processors

• Carl Rimmer

  SSCarpal Tunnel

  Points: 4068

  More actions

  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

   

• Peter Gadsby

  SSCrazy

  Points: 2718

  More actions

  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

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  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/

• Carl Rimmer

  SSCarpal Tunnel

  Points: 4068

  More actions

  February 6, 2007 at 7:36 am

  #688027

  Thanks for the reply.

  Regards

   

  Carl