• sp_configure is showing the raw bitmap value based on the CPU numbers, they are as follows

    exec sp_configure 'affinity mask'

    CPU number 7 6 5 4 3 2 1 0

    Bit map 128 64 32 16 8 4 2 1

    So, CPU 2 and 3 equate to 8 + 4 = 12

    CPU 2, 5 and 7 equate to 128 + 32 + 4 = 164

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉