Linux Database Server CPU Comparisonby Johan De Gelas on June 17, 2005 12:05 AM EST
- Posted in
- IT Computing
Benchmarks IBM DB2 8.2: Intel versus AMD
Below, you will find our results for the different platforms of AMD and Intel. At the last moment, the Pentium 4 670 3.8 Ghz arrived in the labs, so we decided to give this CPU a quick test run. In these tests, we enabled the new Asynchronous I/O feature, which gave the Intel Xeon a small performance boost (4 to7%), while it made the Opteron perform only a tiny bit faster (1%).
|Concurrency|| Dual Xeon
| Single Xeon
|Dual Xeon Nocona||Single Xeon Nocona||Dual Opteron||Dual Opteron||Single Opteron||Dual Opteron||Intel Pentium D Dual Core||Intel Pentium 4|
|3.6 GHz||3.6 GHz||3.6 GHz||3.6 GHz||2.2 GHz||2.4 GHz||2.4 GHz||2.6 GHz||3.2 GHz||3.8 GHz|
All averages are calculated on the concurrency levels from 5 to 50. There is no doubt about it: it pays off big time to invest in a multi-CPU machine in DB2. It is of no use to invest in the fastest single CPU system. A mid-range dual CPU system will easily outperform it.
The table below is an overview of the differences in the CPUs.
|Concurrency||Dual versus Single Xeon Irwindale||Dual versus Single Xeon Nocona||Dual Opteron 250 vs Single||Dual Opteron 2,6 GHz versus Irwindale 3,6 GHz||Xeon Irwindale versus Nocona|
The performance of DB2 scales almost perfectly on the different platforms. Irwindale scales a little better than two other CPUs, probably thanks to the larger L2-cache. However, this does not save Intel from defeat: the Opteron 2.6 GHz is the champion in these tests. What happened? In our previous test, the fastest Xeon (Nocona 3.6 GHz) was a bit faster than the best Opteron (250, 2.4 GHz). First of all, the Opteron 252 scales very well, and is 8% faster than its older 2.4 GHz brother, as the 252 is clocked at 8.3% higher. But the Xeon Irwindale gets a 5% - 7% performance from its larger L2-cache, so that is not the real issue.
However, when we compared a 64 bit with a 32 DB2 instance, the Opteron gained 13% performance from moving to 64 bit, while the Xeon lost 3 to 4%! Secondly, with the 2.4 kernel, the Xeon gained an additional boost from Hyperthreading, while we could not measure this performance increase anymore. Thirdly, it seems that the Opteron gains more due to the move from the 2.4 kernel to 2.6 kernel than the Xeon.
Benchmarks IBM DB2: Single core versus Dual coreWhat about our Dual core Opteron 875/275? We managed to get DB2 running on Gentoo, kernel 2.6.12rc5. You can find the results below. All tests have been performed on the MSI K8Master-FAR2.
|Concurrency||Dual Dual Core AMD||Single Dual Core AMD||Dual Opteron||Quadcore vs Dual||Dualcore versus Dual Single|
|2.2 GHz||2.2 GHz||2.2 GHz|
Simply amazing how much punch the Dual core 275/875 has. It offers a 14% performance increase over a completely similar configured dual CPU Opteron 248 setup. Add a second core, and DB2 8.2 rewards you with another 70% performance increase. And all this is happening on our ATX MSI K8Master-FAR2 board.
Benchmarks IBM DB2: Single versus Dual versus QuadWhat about the “conventional” quad CPU configuration? The Iwill H4103 was our testing platform.
|Concurrency||Dual Opteron 848||Quad Opteron 848||Quad versus Dual|
|2.2 GHz||2.2 GHz|
DB2 continues to scale very well. A 70% performance increase is the result of adding two more CPUs. Notice that the Quad CPU need 20 concurrent connections running many queries to get to the full potential (up to 80% performance increase). The Quad Xeon was unfortunately not available to the lab.