OLTP benchmark: Oracle Charbench “Calling Circle”
Operating System: Windows 2008 Enterprise RTM (64 bit)
Software: Oracle 10g Release 2 (10.2) for 64 bit Windows
Benchmark software: Swingbench/Charbench 2.2
Database Size: 9 GB
Typical error margin: 2-2.5%
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 for 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 second run and later run with a DQL (Disk Queue Length) of 0.2 or lower. In this case, it was rather easy to run the CPU’s at 99% load. Since DQL’s were very similar, we could keep our results of the “Nehalem” article. All configurations use 2 sockets.
The score of the 2.7 GHz Opteron 2384 tells us that a 2.6 GHz Opteron would score about 231. The two extra cores of the Opteron “Istanbul” 2435 add thus about 27% of performance. That is less than what hyperthreading adds to the score of the Xeon X5570, clearly demonstrating what a valuable weapon Hyperthreading is in these low IPC database workloads. The Xeon X5570 performs 50% faster than AMD’s latest six-core. Even if we take in account that the Opteron 2435 competes with the 10% lower clocked X5550, it is clear that the Xeon X55xx series outperforms the best AMD CPUs by a large margin.
40 Comments
View All Comments
befair - Wednesday, June 3, 2009 - link
yeah, yeah, its always "more details review coming soon"smith1795 - Thursday, June 4, 2009 - link
http://cheap-conveyancing-online.blogspot.com
http://gadgets-gizmo.vox.com
http://solicitorwill.blogg.de/">http://solicitorwill.blogg.de/
http://www.blogigo.co.uk/conveyancing_solicitors">http://www.blogigo.co.uk/conveyancing_solicitors
genkk - Tuesday, June 2, 2009 - link
ohhh I see, johan is only doing what his boss (anand) has told him so...aguilpa1 - Monday, June 1, 2009 - link
As an AMD fanboy I skipped to the one metric that AMD shows competitive performance and focused on that ignoring all other.classy - Monday, June 1, 2009 - link
That is laughable. Lets see I have only purchased all Intel servers in the last 7 years. But in the last 2 years anyone who does any system administration knows virtualization has just leaped to the forefront. Its that important. Even email is being virtualized. Databases are still physical and will probably be for some time to come. But make no mistake about it, how well it does at virtualizing is at the top of the list. Especially considering the recent recession. Virtualizing allows more to be done with less of everything. Next time maybe have some experience in something else besides reading the internet and maybe you might understand a thing or two.Natfly - Monday, June 1, 2009 - link
Virtualization isn't the be-all end-all of computing. It definitely can be a way to make more efficient use of your hardware, but the "virtualize everything" mentality isn't going to help you in the long run.solicitorsuk - Saturday, September 26, 2009 - link
This is the thing that i looking for from couple months ago.http://solicitorsuk.blogspot.com/">http://solicitorsuk.blogspot.com/
nycromes - Tuesday, June 2, 2009 - link
I don't think thats really what he/she was saying, they were saying that in terms of the IT world, Virtualization is now one of the (if not the) most important features. Right now, there are major pushes in the industry to make more efficient use of hardware, virtualization is one major part of doing that. I agree that a "virtualize everything" mentality is not good, but the OP makes a great point about the importance of virtualization in todays IT world.Jakey1999 - Thursday, May 6, 2010 - link
Dudes,What would you recommend for a SQL Server 2005 64bit database server? Hybrd, system OTLP and OLAP - 75% read. Thanks. Please respond to e-mail "jerry@tre.wa.gov". Thanks man.
AlexRot - Wednesday, October 7, 2020 - link
Компания Азия-Трейдинг оказывает весь комплекс вэд услуг по таможенному оформлению грузов экспортно-импортного направления. Мы контролируем каждый шаг для того, чтобы Ваши грузы оформлялись без задержек. Доскональное знание условий оформления и профессионализм сотрудников позволяет добиться значительного снижения издержек и максимальной скорости оформления грузов.