SQL Server Standard and CPUs

• Buxton69-502449

  SSCrazy

  Points: 2026

  More actions

  November 1, 2007 at 3:28 am

  #118705

  If you put SQL Server Standard on a server with 8 CPUs how does it choose which 4 it will use? Can you assign which 4 it can use and assign the other 4 to the OS?

  Thanks

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  November 1, 2007 at 3:43 am

  #747358

  Hi,

  Im not sure how it allocate CPU, but i can see in most of the cases like this it is utilizing from CPU 0 to CPU 3.

  Yes you can assign the CPU which sqlserver to make use

  Right click on the sqlserver and then click property

  Goto processor tab

  Then enable \ disable the processor as per your need

  Regards..Vidhya Sagar
  SQL-Articles