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)
Thanks
--Harvinderi think you are probably safer disabling HT for now,
some queries may not run well when using two separate
threads on one physical processor, other may run better on
one than two.
i have seen performance problems with index rebuilds with
HT. Until there is a comprehensive analysis of what runs
well in HT and what does not, you are probably better off
not using this feature
>--Original Message--
>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)
>Thanks
>--Harvinder
>.
>|||Assuming the BIOS is written to Intels specifications, it will number the
processors starting with the first logical processor on each physical
processor, so in your case 0,1
Have a look at
http://www.microsoft.com/windows2000/docs/hyperthreading.doc
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"harvinder" <hs@.metratech.com> wrote in message
news:0bd201c3633b$8a754f70$a501280a@.phx.gbl...
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)
Thanks
--Harvinder|||Thanks Jasper..Did the value of 3 looks good to u for
using only both physical processors that are logical 0,1
Thanks
--Harvinder
>--Original Message--
>Assuming the BIOS is written to Intels specifications, it
will number the
>processors starting with the first logical processor on
each physical
>processor, so in your case 0,1
>Have a look at
>http://www.microsoft.com/windows2000/docs/hyperthreading.d
oc
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"harvinder" <hs@.metratech.com> wrote in message
>news:0bd201c3633b$8a754f70$a501280a@.phx.gbl...
>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)
>Thanks
>--Harvinder
>
>.
>|||Yeah that's right
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"harvinder" <hs@.metratech.com> wrote in message
news:011801c3635e$7183bb00$a601280a@.phx.gbl...
Thanks Jasper..Did the value of 3 looks good to u for
using only both physical processors that are logical 0,1
Thanks
--Harvinder
>--Original Message--
>Assuming the BIOS is written to Intels specifications, it
will number the
>processors starting with the first logical processor on
each physical
>processor, so in your case 0,1
>Have a look at
>http://www.microsoft.com/windows2000/docs/hyperthreading.d
oc
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"harvinder" <hs@.metratech.com> wrote in message
>news:0bd201c3633b$8a754f70$a501280a@.phx.gbl...
>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)
>Thanks
>--Harvinder
>
>.
>