SQL Server Performance Forum – Threads Archive

xeon processor and affinity mask

Hi,
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 Thanks
–Harvinder

---

Harvinder: The post must be in only one Forum. Luis Martin

---

]]>