May 8, 2010

Revisiting disk vibration as a data warehouse performance problem

Last April, I wrote about the problems disk vibration can cause for data warehouse performance. Possible performance hits exceeded 10X, wild as that sounds.

Now Slashdot and ZDnet have weighed in, although for the most part they only are suggesting 50-100% performance hits. One good quote is:

It’s a lot easier to interfere with a moving head arm than it is to mess one up that’s locked on a track, so this isn’t surprising in the least for vibration to affect reads that require numerous long seeks. I’m surprised it’s not worse than they’ve found.

Moving the head requires accelerated head stepping to top speed, stepping to close to the track, slowing down, stopping at the destination track, waiting for the head to settle, and reading an address block to find out where you managed to land. If you find you missed the track, you have to go through the whole seek process again. (usually only once more, those short adjustment hops are pretty reliable because they’re lower speed) But that really hurts your single block read time.

Add to that the fact that the “high performance” drives are making more risky higher speed track changes, which increase the odds of missing your target and make the operation more sensitive to vibration. I’ve written direct HDD io code before, and sure, you can up the step speed to get very nice seek time boosts, but then you start missing your track and start getting reseeks. Usually you go with the fastest that’s acceptably reliable, and that puts you on the bleeding edge of having problems, where things like vibration can run you off the deep end of the bell curve.

Comments

3 Responses to “Revisiting disk vibration as a data warehouse performance problem”

  1. Jochen S on May 8th, 2010 5:11 am

    Just in case you haven’t see this, here’s some information from Sun about disk vibration, including a video of a technician shouting (!) at a disk array and measuring the impact: http://bit.ly/aMqEKo

  2. www.oracledba.in on May 8th, 2010 10:48 am

    i like this

  3. The ongoing struggle » Blog Archive » Dear System Integrators, a few words about screwing on March 10th, 2012 4:19 pm

    [...] 100% true that vibration of components like hard disks is bad. numerous studies have been done that prove that vibration causes performance problems as drives need to do more [...]

Leave a Reply




Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

Login

Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.