Hi ,
I would like to know if some have experience with upgrade INTEL CPU on SQL 2000 DB server .
I have SQL 2000 2* 1233 INTEL Pentium III CPU with 4 GB RAM .
The server main task is log processing from temporary table to Fact table.
I would like to upgrade the CPU to Intel Xeon Processor 1MB cache ~2.4 GHz .
Intel report on ~ 100 performance improvement.
Can someone let me know from his CPU experience what should I expect?It depends. You will have to run some performance monitors on your current box, to see if it is getting bogged down by a lack of CPU. If it is, then yes, the faster CPU could help. If you are more bogged down by disk access, you will see very little performance increase with the new CPUs.
For example, suppose a process takes 10ms of cpu time, and 100ms of disk I/O time. The whole process takes 110 ms. If you get a processor that runs twice as fast, you will end up with a process that runs in 105 ms. Just under a 5% increase in performance.
In general, if your CPU is staying up around 70 - 80%, I would go with the CPU upgrade. If it is consistently less than that, I would not bother.|||Thanks !,
Thank , I have peeks of ~ 20 minute each hour of ~ 80-100% CPU but , I am afraid that it is caused by the SQL server processing (lock management locks for example or other ) so any better CPU will not help ??
Showing posts with label intel. Show all posts
Showing posts with label intel. Show all posts
Friday, March 9, 2012
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...
>
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...
>
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.
>>
>
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...
>
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 Hyper Threading
Hi
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
James
On our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>
|||Have a look here:
http://blogs.msdn.com/slavao/archive...12/492119.aspx
Markus
|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegr oups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archive...12/492119.aspx
> Markus
>
|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer is
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmark
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity to
> throw this away.
>
|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
James
On our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>
|||Have a look here:
http://blogs.msdn.com/slavao/archive...12/492119.aspx
Markus
|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegr oups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archive...12/492119.aspx
> Markus
>
|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer is
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmark
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity to
> throw this away.
>
|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
Intel Hyper Threading
Hi
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
JamesOn our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>|||Have a look here:
http://blogs.msdn.com/slavao/archiv.../12/492119.aspx
Markus|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegroups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archiv.../12/492119.aspx
> Markus
>|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer i
s
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmar
k
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity
to
> throw this away.
>|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
JamesOn our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>|||Have a look here:
http://blogs.msdn.com/slavao/archiv.../12/492119.aspx
Markus|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegroups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archiv.../12/492119.aspx
> Markus
>|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer i
s
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmar
k
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity
to
> throw this away.
>|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
Intel Hyper Threading
Hi
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
JamesOn our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>|||Have a look here:
http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
Markus|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegroups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
> Markus
>|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer is
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmark
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity to
> throw this away.
>|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
>> <Excerpt>
>> So does it mean you have to disable HT when using SQL Server? The answer
>> is it really depends on the load and hardware you are using.
>> You have to test your application with HT on and off under heavy loads to
>> understand HT's implications.
>> </Excerpt>
>> There is no substitute for thorough performance testing when you have a
>> demanding application and/or expect to tax the hardware. I ran a
>> benchmark with our app on a 4-way (8 logical) proc server and we got
>> 15-20% percent improvement with HT enabled at the bios level. It would
>> have been a pity to throw this away.
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
JamesOn our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>|||Have a look here:
http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
Markus|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegroups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
> Markus
>|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer is
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmark
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity to
> throw this away.
>|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
>> <Excerpt>
>> So does it mean you have to disable HT when using SQL Server? The answer
>> is it really depends on the load and hardware you are using.
>> You have to test your application with HT on and off under heavy loads to
>> understand HT's implications.
>> </Excerpt>
>> There is no substitute for thorough performance testing when you have a
>> demanding application and/or expect to tax the hardware. I ran a
>> benchmark with our app on a 4-way (8 logical) proc server and we got
>> 15-20% percent improvement with HT enabled at the bios level. It would
>> have been a pity to throw this away.
Subscribe to:
Posts (Atom)