It’s Not a Record, But It Is The Most Interesting TPC-H Result! No Manly Man SAN Here.

Not a Record, But It Is In My Book
Not a throughput record that is. This new result at 39,614 QphH comes within 2% of Oracle’s previous top ranking in the 300GB scale. Why would Oracle publish a result that doesn’t even beat their own previous result? Price performance is the answer. I also find the deployment architecture to be very interesting.

Oracle still hold the top ranking at 300GB with their December 2006 result of 40,411 QphH at a price/performance of $18.67 $$/QphH. This new result, however, comes in at only $12.57 QphH-33% cost savings for essentially the same performance! What did Oracle do to reduce the cost? Did they use fewer RAC nodes to reduce their own licensing cost? Did they use a better, cheaper SAN? Did they use a cheaper, faster RAC interconnect? No, none of that. In fact:

  • Both results used an 8 node cluster of blade servers
  • Both results used Infiniband for the RAC cluster interconnect
  • Both results used “networked storage”

So what gives?

No SAN.
The December 2006 result of 40,411 QphH used a $393,765 configuration consisting of some 448 disks in a SAN with 32 MSA 1000 controllers (not including spares). This new result, on the other hand, did not use a SAN at all. Instead, there were 8 blade servers (the RAC cluster) attached to 16 storage blades. The storage blades were running RHEL5 and presenting block storage via SRP over Infiniband to the 8 node RAC cluster. What’s that? Yes, Infiniband-a single, unified connectivity model for both RAC interconnect and storage. With this type of storage, Oracle was able to drive the same performance (yeah, I know, within 2%) with only 128 hard drives. All told, the storage configuration was priced at $141,158-a healthy 64% reduction in storage cost!

This is a very, very good day-but not for Manly Man.

I couldn’t be happier!

5 Responses to “It’s Not a Record, But It Is The Most Interesting TPC-H Result! No Manly Man SAN Here.”


  1. 1 Jeremy Schneider August 14, 2007 at 1:26 am

    Wow – that is very cool! Sounds kinda like google.

    I think that the real strength of this is when you combine it with ASM. Oracle automatically makes sure that the data is spread across the LUN’s and manages rebalancing and such. I think that it really could displace storage vendors in a few places.

  2. 2 kevinclosson August 14, 2007 at 4:44 am

    Jeremy,

    Your points are noted, but for whatever reason ASM was not used in this benchmark. However, ASM will undoubtedly play a key part in such storage approaches in the future.

  3. 3 christianbilien August 18, 2007 at 10:21 am

    Kevin,

    Thanks for pointing on this benchmark. I am currently digging into RAC/ASM/IB/blades performance,scalability, maintenance, etc. Though improved in recent months, max IB supported cable length is (unfortunately) still severely hampering SRP as a viable solution for customers for which synchronous replication on a
    remote site cannot be worked around. One of the Cisco IB specialist I talked to recently mentionned that he thought that IB links of a kilometer should come out sometimes in 2008. 11g ASM “fast” resync will also help to get the concept through.


  1. 1 Two Terabytes of Flash SSD Anyone? « Kevin Closson’s Oracle Blog: Platform, Storage & Clustering Topics Related to Oracle Databases Trackback on September 17, 2007 at 5:34 pm
  2. 2 Databases are the Contents of Storage. Future Oracle DBAs Can Administer More. Why Would They Want To? « Kevin Closson’s Oracle Blog: Platform, Storage & Clustering Topics Related to Oracle Databases Trackback on July 14, 2009 at 3:27 pm

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




DISCLAIMER

I work for Amazon Web Services. The opinions I share in this blog are my own. I'm *not* communicating as a spokesperson for Amazon. In other words, I work at Amazon, but this is my own opinion.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,944 other followers

Oracle ACE Program Status

Click It

website metrics

Fond Memories

Copyright

All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2015. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

%d bloggers like this: