|
Home > Archive > MS SQL Data Warehousing > November 2005 > Intel processor identifier tool, where is it?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Intel processor identifier tool, where is it?
|
|
|
| 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.
| |
| Mike Epprecht \(SQL MVP\) 2005-11-19, 9:23 am |
| 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...
>
>
| |
| Jasper Smith 2005-11-19, 1:23 pm |
| http://www.intel.com/cd/ids/develop...ology/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@hotmai
l.com> wrote in message
news:ObfPWET7FHA.2692@tk2msftngp13.phx.gbl...
> http://www.intel.com/cd/ids/develop...ology/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...
>
>
| |
| Andrew J. Kelly 2005-11-20, 8:23 pm |
| 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...
>
>
|
|
|
|
|