Oracle Scratchpad

October 5, 2012

SSD

Filed under: Exadata,Infrastructure,Oracle,Performance,redo — Jonathan Lewis @ 1:04 pm BST Oct 5,2012

There’s never enough time to read everything that’s worth reading, so even though Guy Harrison’s blog is one of the ones worth reading I find that it’s often months since I last read it. Visiting it late last night, I found an interesting batch of articles spread over the last year about the performance of SSD – the conclusions may not be what you expect, but make sure you read all the articles or you might end up with a completely misleading impression:

Don’t forget to read the comments as well. For other notes Guy has written about SSD, here’s a URL for his SSD tag.

1 Comment »

  1. I’m not too surprised about Guy’s conclusions about redo on SSD.
    This is not because I am expert on SSD (I can spell it) but because I attended a presentation a couple of years ago by a couple of engineers from LSI.
    Their job was to do performance testing of the new LSI SSD product for Oracle Flashcache.
    They were surprised to consistently find that redo performed better on spinning rust than on SSD.
    After discussing it with some other engineers they had a better understanding of the limitations of SSD when used with redo.
    The Powerpoint for that presentation is here:

    http://www.oswoug.org/Slides/LSI/SolidStateStorageinOracleEnvironmentsv4.pptx

    The most interesting redo bits aren’t available in the presention, you had to be there.
    There is mention however that due to sequential writes redo performs better on HDD.

    Comment by Jared — October 5, 2012 @ 1:47 pm BST Oct 5,2012 | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

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

Theme: Rubric. Get a free blog at WordPress.com

Follow

Get every new post delivered to your Inbox.

Join 4,257 other followers