Disabling a CPU in SQL Server 2005

  • Here is my situation: I have a repurposed Server with Two (2) CPUs, lots of memory and HD space, but I have only One (1) SQL Server License remaining. Can I install SQL Server to use only the single license or how would I configure SQL Server 2005 to disable a CPU?

    I appreciate the help.

    Greg

  • You have to take one CPU out or disable it at the BIOS level in order to be compliant with the SQL Server licencing. You are able to use CPU affinity in sql server to make it use (mostly) one CPU but for licencing purposes you have to licence against all available CPUs in Windows.

  • You can disable CPUs with the affinity mask, but MS doesn't recognize that. The other solution (besides removing a CPU) is to run a VM and allocate only one CPU to the VM.

    Watch out for IO.

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

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