Post reply

Set number of CPUs used by SQL Server 2005

  • July 2, 2008 at 11:09 pm

    #123604

    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

    #837629

    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

    #838487

    Thanks!

    Do you know if this configuration is also compliant with the license agreements?

  • July 5, 2008 at 7:09 am

    #838493

    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