Re: Oracle 7.3.4 performance on 2-450Mhz vs 4-200Mhz

http://www.tpc.org/new_result/c-result1.idc?id=97122901

http://www.tpc.org/new_result/c-result1.idc?id=98051102

http://www.tpc.org/new_result/c-result1.idc?id=98110303

You can see that the 4 PPro 200/1M are a better choice, especially for a DB server with many sessions.
The 4 PPro 200 /512k are still a little better than the 2 PII 450 and the thread variation differences are even bigger.

In most real world multi-session/(threads) environments the 4 PPros are a better choice. With fewer sessions the PIIs become more attractive. One does not have run NT on these machines - they are all Solaris 2.6, 7 certified.
The tpc data was gathered using NT though. With Oracle on Solaris the performance should go up about 10-15% as compared to NT.

Stilian

David Sisk wrote:
>
> Hi:
>
> I would assume that since you're using Compaq boxes, you're using WindowsNT.
> WindowsNT's processor scaleability pretty much stinks. You'll get better
> performance out of 2 faster CPU's than you will out of 4 slower CPU's.
>
> --
> David C. Sisk
> Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at
> http://www.ipass.net/~davesisk/oont.htm
> Like original modern rock? Listen to song samples and buy a CD at
> http://www.mp3.com/disparityofcult
>
> jboehler_at_my-deja.com wrote in message <7qgii2$h47$1_at_nnrp1.deja.com>...
> >Given the choice of running Oracle 7.3.4 on one
> >of the following boxes, which would perform,
> >better:
> >
> >Compaq Proliant 6500R 2Gig RAM, CPUs 4 @ 200Mhz
> >Compaq Proliant 5500R 2Gig RAM, CPUs 2 @ 450Mhz
> >
> >Given all else is the same are we better off with
> >the 2 CPUs at 450Mhz or 4 CPUs @ 200Mhz?
> >
> >Thanx,
> >Jeff Boehlert
> >jboehler_at_ctron.com
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
Received on Wed Sep 01 1999 - 12:36:44 CDT