Home / server / Questions / 361173
Accepted
Robin
Asked: 2012-02-18 04:26:25 +0800 CST

Can I restrict how many CPUs SQL Server 2005 uses?

  • 772

I have a SQL Server 2005 instance running on a production server. CPU load is relatively low in part thanks to some recent improvements in the code. I'm trying to work out if I could safely reduce the number of CPUs in the machine and would like to test that out before actually getting them removed.

Is it possible to tell SQL Server 2005 to just use say 4 of the 8 CPUs in the machine to test this out?

Thanks, Robin

sql-server-2005 cpu-usage

1 Answers

  1. Best Answer

    Yes - just set the processor affinity accordingly. The net has a lot of fancy coloured walkthroughs. Note that the Express Edition only ever uses a single thread, so it is hard-limited to using 1 CPU already.

    • 3