Dual-core CPU vs. very large cache

Shane Ambler Shane at 007Marketing.com
Tue Apr 25 17:04:04 UTC 2006

On 25/4/2006 22:37, "Bill Moran" <wmoran at collaborativefusion.com> wrote:

> [First off, the list archives for this list don't seem to be
> searchable.  I get the following error:
> Unable to read document excerpts
> '/usr/local/mailman/archives/private/freebsd-performance/htdig/db.excerpts'
> Did you run htdig?]
> So ... on to the question.
> We have some database servers that we're looking to replace with
> beefier hardware, mainly because we're expecting our customer base
> to grow a lot in the near future.
> The current hw is Dell 2850 servers.  These are dual proc (each proc
> is hyperthreaded) with Dell PERC controllers driving 4 SCSI-320
> disks in a RAID-10.
> We're doing our best to simulate high-load in the lab, and the
> database consistently bottlenecks on CPU usage.  I'm assuming that
> the combination of plenty of RAM and high-speed disks has led to
> the CPU being the slowest part of the system.
> We're considering two alternatives for the newer hardware:
> 1) Intel HT CPUs with 8M cache
> 2) Intel dual-core procs
> Our current Dells have 2M cache, and I'm trying to determine whether
> the 8M cache will make a significant difference or not.  Can someone
> recommend a testing procedure for determining whether adding cache is
> worthwhile or not?  I can simulate a test load at any time, but I
> don't know how to tell whether the cache is the bottleneck of the
> CPU or not.

Cache helps speed things up by keeping code/data in faster memory - this
helps speed things up when the same code/data is used repeatedly.

>From the info you have given I am guessing that you have many users who are
loading the system up to capacity and that the database is fairly large
(a few Gig).
On that premise I would recommend the dual core CPU's (two or more dual core
xeon's - not P4's) - it sounds like they would be working with more data
than would be kept in cache so the extra cache wouldn't increase performance
a great deal and with many users loading the system the more cpu's of the
dual cores cpu's would allow more requests to be processed at the same time.

At the high end of server hardware have you considered Opteron servers? The
Tyan Thunder K8QW can run four dual core Opteron's and can take a
daughtercard that will allow it to have a total of eight dual core
Opteron's. Even the K8QSD Pro can run four dual core Opterons.

Start with the two cpu config and if the load gets too high add another two
- you then still have the option of adding another four if the need arises.

More information about the freebsd-performance mailing list