Elisabeth Stahl on Benchmarking and IT Optimization

Posts Tagged ‘DB2

Back in Time with Oracle

with one comment

Some of you may know that this week was a very big one for “Back to the Future” movie fans. On Wednesday, Oct. 21, 2015, at 4:29 p.m., our today caught up to the tomorrow depicted in “Back to the Future, Part II.” In that 1989 film, a DeLorean time machine appears from 30 years in the past.

To those who love time travel, this is a really big deal. Some towns even went so far as to rename themselves to the featured city in the film. Ceremonies worldwide were performed at exactly 4:29PM.

And this reminded me of a benchmark result that was just published today by Oracle on the SAP SD benchmark.

As we move into newer digital workloads, some of the older industry benchmarks have gone by the wayside. Many of us have spent a lot of time analyzing these newer workloads and developing new metrics for them. But one classic benchmark is still extremely appropriate for many of today’s applications – and that is the suite of SAP benchmarks.

But this new Oracle result just published is clearly dated — even though it is a brand new result on a brand new Oracle SPARC system. The IBM Power Systems result with DB2 from over 1 year ago is over 2X better performance per core than this new Oracle SPARC result. (1)

What’s really exciting, unlike this new benchmark result, is that many of the predictions of the future in the “Back to the Future” movie were right on. But I am still waiting for the dog-walking drone.


The postings on this site solely reflect the personal views of the author and do not necessarily represent the views, positions, strategies or opinions of IBM or IBM management.

(1)IBM Power Enterprise System E870 on the two-tier SAP SD standard application benchmark running SAP enhancement package 5 for the SAP ERP 6.0 application; 8 processors / 80 cores / 640 threads, POWER8; 4.19GHz, 2048 GB memory, 79,750 SD benchmark users, running AIX® 7.1 and DB2® 10.5, dialog response: 0.97 seconds, order line items/hour: 8,722,000, dialog steps/hour: 26,166,000, SAPS: 436,100, Database response time (dialog/update): 0.013 sec / 0.026 sec, CPU utilization: 99%, Cert #2014034 vs. Oracle SPARC T7-2 result of 30,800 users, Average dialog response time: 0.96 seconds, Fully processed order line items/hour: 3,372,000, Dialog steps/hour: 10,116,000, SAPS: 168,600, Average database request time (dialog/update):0.022 sec / 0.047 sec, CPU utilization of central server:98%, Operating system, central server: Solaris 11, RDBMS: Oracle 12c, SAP Business Suite software:SAP enhancement package 5 for SAP ERP 6.0, Certification number: #2015050, SPARC T7-2, 2 processors / 64 cores / 512 threads,SPARC M7 4.133 GHz, 16 KB (D) and 16 KB (I) L1 cache per core, 256 KB (D) L2 cache per 2 cores and 256KB (I) per 4 cores, 64 MB L3 cache per processor, 1024 GB main memory

SAP and all SAP logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries. All other product and service names mentioned are the trademarks of their respective companies.

technorati tags: , , ,,,,,,,,,,,


Written by benchmarkingblog

October 23, 2015 at 12:59 pm

Posted in Oracle, SAP

Tagged with , , , , , ,

eX5 Does Mile High TPC-C

leave a comment »

I often get tired during a long hike — but nothing a sit down and a few peanut M&Ms can’t take care of. But a few years ago, at about 9000 feet on the edge of a glacier in Montana, that certainly didn’t do the trick. I would walk about three steps, have to sit on a rock, and then I felt as if I wanted to sleep forever. Instead of the usual pondering of how many more miles did we have and how much higher did we have to go, I started to ask deeper questions like why in the world I was doing this at all. The view of the glacier was tremendous but was it worth the feeling that my body had been taken over by aliens?

When I think about “highest ever” I now wonder:

  • Is it possible to enjoy hiking in the Rocky Mountains just for the weekend without acclimation?
  • When the Junior Olympics are in Denver, do the athletes who make their homes in higher altitudes have an advantage?
  • When planning a trip, do I now add altitude to the list of things I need to worry about besides weather, direct flights, crowds, and the language I have to communicate in?


But for our “highest ever” this week there are no questions. Just pure celebration. You see, the IBM System x3850 X5 and DB2 just delivered the highest x86-64 performance score ever achieved on the TPC-C benchmark.(1)

The TPC-C benchmark simulates an order-entry environment of a wholesale supplier — entering and delivering orders, recording payments, checking the status of orders, and monitoring the level of stock at the warehouses. TPC-C represents any industry that must manage, sell, or distribute a product or service. Current results show that clients who deploy IBM technology could see more orders entered, faster monitoring, distribution, and delivery.

This configuration used several cool newer technologies — IBM eX5 with E7 processors, MAX5 memory expansion, the amazing DB2 9.7, and SSD storage.

So tell your “highest ever” story here. Keeping it clean, of course.


(1) IBM System x®3850 X5 (Intel Xeon E7-8870 processors 2.40GHz, 4 processors/40 cores/80 threads) result of 3,014,684 tpmC, $.59 USD/tpmC, available 9/22/11, DB2 9.7, SUSE Linux® Enterprise Server 11 (SP1),
Source: Results current as of 8/3/11.

TPC-C ,TPC-H, and TPC-E are trademarks of the Transaction Performance Processing Council (TPPC).

The postings on this site solely reflect the personal views of the author and do not necessarily represent the views, positions, strategies or opinions of IBM or IBM management.

technorati tags: , , , , ,,,,,,,,,,,,,

Written by benchmarkingblog

August 3, 2011 at 3:29 pm

Posted in DB2, MAX5, SSD, TPC, x3850, X5

Tagged with , , ,

%d bloggers like this: