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,
Scott
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
|||"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...
>
|||> 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...
> 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...[vbcol=seagreen]
> So, 0-3 are physical processors and 4-7 are virtual/hyperthreaded?
>
> "Tibor Karaszi" wrote:
|||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...
>