TPC-H benchmark result

Jesper Frimann (jesperfrimann@gmail.com) on 9/28/11 wrote:
---------------------------
>Michael S (already5chosen@yahoo.com) on 9/27/11 wrote:
>
>>Oracle published 1000GB TPC-H benchmark result:
>>
>>Oracle SPARC T4-4 Server, 4S/32C/256T, Oracle SPARC T4, 3GHz, 512GB, Solaris 10
>>8/11, Oracle 11g R2 EE with Partitioning - 201,487 QphH@1000GB at 4.60 USD per QphH@1000GB
>>
>>By comparison to other "traditional" database submissions that's damn good score.
>>
>>HP ProLiant DL980 G7, 8S/80C/160T, Intel Xeon E7-4870, 2.40 GHz, 2048GB, Ws2008
>>R2 EE, SQL Server 2008 R2 EE - 219,888 QphH@1000GB at 1.86 USD per QphH@1000GB
>>SPARC Enterprise M8000 Server, 16S/64C/128T, Fujitsu SPARC64 VII+, 3GHz, 512GB,
>>Solaris 10 8/11, Oracle 11g R2 EE with Partitioning - 209,534 QphH@1000GB at 9.53 USD per QphH@1000GB
>>IBM System x3850 X5 8P, 8S/80C/80T, Intel Xeon E7-8870, 2.40 GHz, 2048GB, Ws2008
>>R2 EE, SQL Server 2008 R2 EE - 173,962 QphH@1000GB at 1.37 USD per QphH@1000GB
>>IBM Power 780 Model 9179-MHB, 8S/32C/128T, IBM Power7, 4.14GHz, 512GB, RHEL 6, Sybase IQ Single Application
>>Server Edition v.15.2 ESD #2 - 164,747.2 QphH@1000GB at $6.85 USD per QphH@1000GB
>>HP Integrity Superdome 2, 16S/64C/64T, Intel Itanium 9350, 1.73GHz, 512 GB, HP-UX
>>11i v3, Oracle 11g R2 EE with Partitioning - 140,181 QphH@1000GB at 12.15 USD per QphH@1000GB
>>
>
>To be quite frank I think that Oracle has cracked this benchmark. Honestly a 32
>core T4 machine doing 90% of the work of a 80 core DL980 ? That would mean that
>a T4 core is twice as fast as a Westmere-EX core. weeeeeeelll..
>
>The difference in the result is not due to the compute power of the servers.
>
>If you look at all the submissions except the Oracle DB on SPARC then the queries
>have much longer run time for Q1, Q9,Q13, Q18 and Q21. Specially if you compare
>to the SD2 result the difference becomes obvious (oracle on UNIX versus Oracle on UNIX).
>IMHO they have cracked the benchmark.
>
>// Jesper

Its funny how when IBM shows a significantly higher benchmark result, like on SPEC CPU2006 or even SAP SD 2-Tier, certain folks here say *wow*, this is an amazing CPU and dont even question the fact that maybe IBM has cracked the benchmark, yet here, SPARC T4 does incredibly well on TPC-H, an independently audited benchmark, much more real world benchmark (than spec cpu will ever be), and where IBM and HP have recently published results so therefore Oracle must have cracked the benchmark? If anything, I think Oracle has cracked running a database seriously fast on SPARC HARDWARE and its going to be interesting how IBM or even HP will be able to counter this! IBM wont even dare run DB2 on TPC-H-why not? And why not AIX? Anybody question these things?