Post reply

setting affinity mask in sql 2008 ( not R2)

  • February 23, 2012 at 4:21 am

    #251947

    I need to limit the number of CPU's to 20 for an instance of SQL Server 2008 (Not R2).

    Based on the Technet article, Each CPU maps to a bit in a bitmap. e.g to use the first 3 procs i would use the bitmap 00000111.

    That is fine up to 8 proc's but what if i want to use 20 procs? Do i use a bitmap of 11111111111111111111 ?

    I think i set the cpu affinity to 1048575 ( which is the decimal conversion of 11111111111111111111)

    I cannot test this on a test server which is why im unsure if that will work. Any Ideas?

  • February 23, 2012 at 4:34 am

    #1450752

    if you right click the server, then go to processors and select the 20 cpu's you want it to use via the gui, then instead of hitting ok, use the script button at the top to output the result set to a query window, it should give you the t-sql needed

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

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