Re: Best chip for Oracle AMD, INTEL, SPARC

On Jul 11, 10:02 am, "awatkins1..._at_googlemail.com" <awatkins1..._at_googlemail.com> wrote:
> I know you are going to say that it all depends on the O/S, but if you
> can forget that for the minute, does it matter what the CPU is when
> your are compare the Intel Xeon Quads, AMD Quads and Sun SPARC chips.
>
> Does the cache make a big difference, since you think then SPARC /
> INTEL would be best and you would never consider AMD.
>
>   SPARC T2        =   4 MB  L2
>   UltraSPARC IV  =   2MB L2
>   INTEL Xeon       =   2MB L2
>   AMD Opteron     =   512K L2
>
> Cheers
>
> Andrew

We completed a bunch of benchmarking recently. It is really best to do your own benchmarking with your own data and some custom SQL that attempts to make call patterns that actually reflect what your company needs to run.

But anyway, we tried to keep AMD and Sun in the running. The SUN machines scale out well as # of connections go up but are very slow in single threaded performance. Isn't each dedicated server session essentially single threaded ... ( sorry of course they are ).

So for us the new Intel quad core Xeon's just absolutely tore up the performance benchmarking we did. They have 24 meg of L2 cache I think.

The AMD quad core's were not available at the time we did our benchmarking. Received on Fri Jul 11 2008 - 19:38:19 CDT