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.
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/
"Jj" <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/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.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
"Jj" <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
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>
|||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/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>

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.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/
"Jj" <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/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>|||http://www.intel.com/cd/ids/develop...122.h
tm
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
"Jj" <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/develop...122
.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
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>|||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/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>

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.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/developer/asmo-na/eng/dc/threading/methodology/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/developer/asmo-na/eng/dc/threading/methodology/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.
>>
>

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.
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/
"Jj" <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/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.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
"Jj" <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
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>
|||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/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>

Integration Services log report pack - provided by Microsoft - US date format issue

Hello all,
Microsoft provides a report pack of RS reports to use with
Integration
Services standard logging.
The link is here
http://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad5-4a54-b62c-13ffcd114a73&DisplayLang=en#QuickInfoContainer
I have been trying to use these reports in the UK and have come
across
a problem with the date formatting. The reports seem to expect the
date formatting in the report parameters to be in US format. I have
changed all the report language settings to UK - English and the date
formatting in the datasets that supply the parameter values all use
ANSI dates (format 102), but I still get date conversion errors when
trying to return the datasets unless I input the dates in US format.
Any advice on how to get around this issue would be greatly
appreciated.
ThanksOn 26 Mar, 14:31, "weelin" <wee...@.gmail.com> wrote:
> Hello all,
> Microsoft provides a report pack of RS reports to use with
> Integration
> Services standard logging.
> The link is herehttp://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad...
> I have been trying to use these reports in the UK and have come
> across
> a problem with the date formatting. The reports seem to expect the
> date formatting in the report parameters to be in US format. I have
> changed all the report language settings to UK - English and the date
> formatting in the datasets that supply the parameter values all use
> ANSI dates (format 102), but I still get date conversion errors when
> trying to return the datasets unless I input the dates in US format.
> Any advice on how to get around this issue would be greatly
> appreciated.
> Thanks
As a follow-up, I have found that the only way to run the report is
via Internat Explorer browser AFTER setting the locale of the browser
to US-English so that it passes the date parameters in the correct
format. Obviously, this is not a practical solution, so if anyone has
found a proper solution, please let me know.
Thanks