July 2, 2008 at 11:09 pm
How can I set the number of CPUs used by SQL Server 2005 to fit the license?
This is not a question regarding performance, maxdop and so on.
Example: you have a license for 1 CPU and you want to move your SQL Server to another machine with 2 sockets. During the installation there is no possibility to tell the server to use 1 CPU only. I also cannot find any configurable options...
Thanks...
July 3, 2008 at 12:55 am
This can be configured using the Affinity Mask server option. Run sp_configure (with Show Advanced Options on) to see this option, or right-click on your server in SSMS and select Properties then Processors to enable/disable processors used by SQL Server.
July 5, 2008 at 5:58 am
Thanks!
Do you know if this configuration is also compliant with the license agreements?
July 5, 2008 at 7:09 am
including all other information, you should also study this: http://www.directionsonmicrosoft.com/sample/DOMIS/update/2008/06jun/0608pmccu.htm
Maninder
www.dbanation.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply