AMD's 12-core "Magny-Cours" Opteron 6174 vs. Intel's 6-core Xeonby Johan De Gelas on March 29, 2010 12:00 AM EST
- Posted in
- IT Computing
OLTP benchmark Oracle Charbench “Calling Circle”
|Oracle Charbench Calling Circle|
|Operating System||Windows 2008 Enterprise Edition (64-bit)|
|Software||Oracle 10g Release 2 (10.2) for 64-bit Windows|
|Benchmark software||Swingbench/Charbench 2.2|
Calling Circle is an Oracle OLTP benchmark. We test with a database size of 9 GB. To reduce the pressure on our storage system, we increased the SGA size (Oracle buffer in RAM) to 10 GB and the PGA size was set at 1.6 GB. A calling circle tests consists of 83% selects, 7% inserts and 10% updates. The “calling circle” test is run for 10 minutes. A run is repeated 6 times and the results of the first run are discarded. The reason is that the disk queue length is sometimes close to 1, while the subsequent runs have a DQL (Disk Queue Length) of 0.2 or lower. In this case it was rather easy to run the CPUs at 99% load. Since DQLs were very similar, we could keep our results from the Nehalem article.
As we noted in our previous article, we work with a relatively small database. The result is that the benchmark doesn't scale well beyond 16 cores. The Opteron 6174 has a 10MB L3 cache for 12 cores, while the Opteron 2435 has 6MB L3 for 6 cores. The amount of cache might explain why the Intel Xeons scale a lot better in this benchmark. For this kind of OLTP workload is the Opteron 6174 not the right choice. To go back to the car analogy earlier: the muscle car is burning rubber while spinning its wheels, but is not making much progress.