SQL Server Performance

xeon processor and affinity mask

Discussion in 'Performance Tuning for Hardware Configurations' started by harvinder, Aug 15, 2003.

  1. harvinder New Member

    We want to test the setting of affinity mask on out queries. we have 2 xeon processor machine so it looks like 4 processors.....i want to use both the physical processors and not the logical processor so we are setting the value of affinity mask to 3. But how can we make sure
    that it is using 2 physical processor and not 2 logical processors of same physical processor....where can we see this in windows task manager or performance monitor(i
    didn't find any option that differentiate between logical and physical processors)
    We just want to make sure that we are setting the right value of affinity mask

  2. Luis Martin Moderator


    The post must be in only one Forum.

    Luis Martin

Share This Page