Hyperthreading

Hi,
I have a 4 processor server with hyperthreading enabled. The
processors show up in SQL as Processors 0-7. My question is, which numbers
are physical processors and which numbers are the virtual/hyperthreaded
processors? The reason I want to know is that I want to take away 1 physical
and 1 virtual processor from the processors that SQL is allowed to use.
Thanks,
ScottThe firmware/hardware manufacturers are recommended by Intel to make it like following:
Phy0 = Log0
Phy1 = Log1
Phy2 = Log2
Phy3 = Log3
Phy0 = Log4
Phy1 = Log5
Phy2 = Log6
Phy3 = Log7
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:9095D9D1-FE9A-4536-8BA7-96FF93634660@.microsoft.com...
> Hi,
> I have a 4 processor server with hyperthreading enabled. The
> processors show up in SQL as Processors 0-7. My question is, which numbers
> are physical processors and which numbers are the virtual/hyperthreaded
> processors? The reason I want to know is that I want to take away 1 physical
> and 1 virtual processor from the processors that SQL is allowed to use.
> Thanks,
> Scott|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eE9lDgcmFHA.3544@.TK2MSFTNGP15.phx.gbl...
> The firmware/hardware manufacturers are recommended by Intel to make it
> like following:
> Phy0 = Log0
> Phy1 = Log1
> Phy2 = Log2
> Phy3 = Log3
> Phy0 = Log4
> Phy1 = Log5
> Phy2 = Log6
> Phy3 = Log7
>
So if I am reading this correctly, if I wanted to remove the 4th processor
(both physical and hyperthreaded), I would remove the Log3 and Log7...
Rick Sawtell|||So, 0-3 are physical processors and 4-7 are virtual/hyperthreaded?
"Tibor Karaszi" wrote:
> The firmware/hardware manufacturers are recommended by Intel to make it like following:
> Phy0 = Log0
> Phy1 = Log1
> Phy2 = Log2
> Phy3 = Log3
> Phy0 = Log4
> Phy1 = Log5
> Phy2 = Log6
> Phy3 = Log7
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Scott" <Scott@.discussions.microsoft.com> wrote in message
> news:9095D9D1-FE9A-4536-8BA7-96FF93634660@.microsoft.com...
> > Hi,
> > I have a 4 processor server with hyperthreading enabled. The
> > processors show up in SQL as Processors 0-7. My question is, which numbers
> > are physical processors and which numbers are the virtual/hyperthreaded
> > processors? The reason I want to know is that I want to take away 1 physical
> > and 1 virtual processor from the processors that SQL is allowed to use.
> >
> > Thanks,
> > Scott
>|||> So if I am reading this correctly, if I wanted to remove the 4th processor (both physical and
> hyperthreaded), I would remove the Log3 and Log7...
Yep.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:ejUJKjcmFHA.3336@.tk2msftngp13.phx.gbl...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:eE9lDgcmFHA.3544@.TK2MSFTNGP15.phx.gbl...
>> The firmware/hardware manufacturers are recommended by Intel to make it like following:
>> Phy0 = Log0
>> Phy1 = Log1
>> Phy2 = Log2
>> Phy3 = Log3
>> Phy0 = Log4
>> Phy1 = Log5
>> Phy2 = Log6
>> Phy3 = Log7
>>
> So if I am reading this correctly, if I wanted to remove the 4th processor (both physical and
> hyperthreaded), I would remove the Log3 and Log7...
>
> Rick Sawtell
>|||I'm not sure that you refer to the two logical processors on one physical processor as
"virtual/hyperthreader" vs "physical". But, yes, you get the idea.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:0B568019-6053-43F8-8B35-D79FBEF32C9D@.microsoft.com...
> So, 0-3 are physical processors and 4-7 are virtual/hyperthreaded?
>
> "Tibor Karaszi" wrote:
>> The firmware/hardware manufacturers are recommended by Intel to make it like following:
>> Phy0 = Log0
>> Phy1 = Log1
>> Phy2 = Log2
>> Phy3 = Log3
>> Phy0 = Log4
>> Phy1 = Log5
>> Phy2 = Log6
>> Phy3 = Log7
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Scott" <Scott@.discussions.microsoft.com> wrote in message
>> news:9095D9D1-FE9A-4536-8BA7-96FF93634660@.microsoft.com...
>> > Hi,
>> > I have a 4 processor server with hyperthreading enabled. The
>> > processors show up in SQL as Processors 0-7. My question is, which numbers
>> > are physical processors and which numbers are the virtual/hyperthreaded
>> > processors? The reason I want to know is that I want to take away 1 physical
>> > and 1 virtual processor from the processors that SQL is allowed to use.
>> >
>> > Thanks,
>> > Scott
>>|||Actually even though they suggest that there are several variations. There
is a utility on Intel's web site (somewhere<g>) that will supposedly show
you the layout for that particular configuration.
--
Andrew J. Kelly SQL MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eE9lDgcmFHA.3544@.TK2MSFTNGP15.phx.gbl...
> The firmware/hardware manufacturers are recommended by Intel to make it
> like following:
> Phy0 = Log0
> Phy1 = Log1
> Phy2 = Log2
> Phy3 = Log3
> Phy0 = Log4
> Phy1 = Log5
> Phy2 = Log6
> Phy3 = Log7
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Scott" <Scott@.discussions.microsoft.com> wrote in message
> news:9095D9D1-FE9A-4536-8BA7-96FF93634660@.microsoft.com...
>> Hi,
>> I have a 4 processor server with hyperthreading enabled. The
>> processors show up in SQL as Processors 0-7. My question is, which
>> numbers
>> are physical processors and which numbers are the virtual/hyperthreaded
>> processors? The reason I want to know is that I want to take away 1
>> physical
>> and 1 virtual processor from the processors that SQL is allowed to use.
>> Thanks,
>> Scott
>