Elisabeth Stahl on Benchmarking and IT Optimization

Posts Tagged ‘11g

All I Want for Christmas is a Good T4 Benchmark

with 7 comments

I read an article the other day about a Santa school where aspiring Santas go to learn about how to be Santa Claus. Important concepts like how to comb your beard, how to make that amazing Ho Ho Ho, and where to properly keep your hands when a kid is on your lap.

In this economy one of the new lessons that the Santa school offers is on how to reduce kids’ expectations. Santa’s workshop has too many toys to produce Johnny, Santa can’t fit everything into his sack, a bunch of elves got sick.

Oracle announced a new TPC-H BI 3TB benchmark result today on the Oracle SPARC T4-4 server. Expectations surely need to be reduced on this one because here’s what you need to know:

  • Oracle once again used an embarrassing amount of storage to run this benchmark — almost three times the amount of storage that IBM used.(1)
  • Oracle once again used 128 query streams for this benchmark compared with IBM’s 8. TPC-H has a limited number of query variations; so when you run a lot of streams, you have a high probability that the same queries will be requested more than once. Oracle is greatly increasing the probability that they will have the results of the queries stored in their cache — which may not be representative of how their product would perform in a truly ad hoc query environment.
  • Oracle once again published a benchmark where the configuration isn’t even available — until May 31, 2012.
  • Oracle once again included extremely minimal support in their pricing. Does $2300 a year sound like what you are paying for software “incident server support” . . . ?



The most important lesson for Santas — Never promise anything.


(1)IBM POWER 780 (8 sockets/32 cores/128 threads) 192,001 QphH@3000GB, $6.37/QphH@3000GB, available 11/30/11, 15,610 GB storage. Oracle SPARC T4-4 server (4 sockets/32 cores/256 threads) 205,792 QphH@3000GB, $4.10/QphH@3000GB, available 5/31/12, 45,600 GB storage.
Source: Results current as of 11/30/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

November 30, 2011 at 11:14 am

Posted in Oracle, POWER7, SPARC T4, TPC-H

Tagged with , , , , ,

%d bloggers like this: