Hi,

I have lost the link where there is a tool to identify the processors in my
server.
to identify which one is the physical and which one is the HT.

any one can help me?

thanks.

Jerome.

Hi

On a box with 4 HT physical processors, Windows looks at them as follows:
0,1 2,3 are the 1st 'processor' on a chip
4,5,6,7 are the 2nd 'processor' on a chip.

So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Jéjé" <willgart_A_@hotmail_A_.com> wrote in message
news:eHzD6y36FHA.1248@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> I have lost the link where there is a tool to identify the processors in
> my server.
> to identify which one is the physical and which one is the HT.
>
> any one can help me?
>
> thanks.
>
> Jerome.
>
>

thanks.

"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:e1BtuyQ7FHA.3984@TK2MSFTNGP11.phx.gbl...
> Hi
>
> On a box with 4 HT physical processors, Windows looks at them as follows:
> 0,1 2,3 are the 1st 'processor' on a chip
> 4,5,6,7 are the 2nd 'processor' on a chip.
>
> So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Jéjé" <willgart_A_@hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@TK2MSFTNGP14.phx.gbl...
>> Hi,
>>
>> I have lost the link where there is a tool to identify the processors in
>> my server.
>> to identify which one is the physical and which one is the HT.
>>
>> any one can help me?
>>
>> thanks.
>>
>> Jerome.
>>
>>
>
>

http://www.intel.com/cd/ids/develope...logy/19122.htm

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"Jéjé" <willgart_A_@hotmail_A_.com> wrote in message
news:eHzD6y36FHA.1248@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> I have lost the link where there is a tool to identify the processors in
> my server.
> to identify which one is the physical and which one is the HT.
>
> any one can help me?
>
> thanks.
>
> Jerome.
>
>

thanks !
finally my physical processors are the 0,2,4&6

"Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
news:ObfPWET7FHA.2692@tk2msftngp13.phx.gbl...
> http://www.intel.com/cd/ids/develope...logy/19122.htm
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Jéjé" <willgart_A_@hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@TK2MSFTNGP14.phx.gbl...
>> Hi,
>>
>> I have lost the link where there is a tool to identify the processors in
>> my server.
>> to identify which one is the physical and which one is the HT.
>>
>> any one can help me?
>>
>> thanks.
>>
>> Jerome.
>>
>>
>
>

Actually Mike I believe it depends on the motherboard as to the order. Some
are 0123 and others are 0,2,4,6.

--
Andrew J. Kelly SQL MVP


"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:e1BtuyQ7FHA.3984@TK2MSFTNGP11.phx.gbl...
> Hi
>
> On a box with 4 HT physical processors, Windows looks at them as follows:
> 0,1 2,3 are the 1st 'processor' on a chip
> 4,5,6,7 are the 2nd 'processor' on a chip.
>
> So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Jéjé" <willgart_A_@hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@TK2MSFTNGP14.phx.gbl...
>> Hi,
>>
>> I have lost the link where there is a tool to identify the processors in
>> my server.
>> to identify which one is the physical and which one is the HT.
>>
>> any one can help me?
>>
>> thanks.
>>
>> Jerome.
>>
>>
>
>