Integrated Security: processor

Showing posts with label processor. Show all posts

Friday, March 9, 2012

Intel Xeon Processor Vs. INTEL Pentium III

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 ??

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.
>>
>

Friday, March 9, 2012

Intel Xeon Processor Vs. INTEL Pentium III

Intel processor identifier tool, where is it?

Intel processor identifier tool, where is it?

Intel processor identifier tool, where is it?

Intel processor identifier tool, where is it?

Integrated Security

Blog Archive

About Me