Home Forums SQLServerCentral.com Editorials SSD Lifetimes RE: SSD Lifetimes

  • November 26, 2012 at 11:57 am

    #1562348

    Steve Jones - SSC Editor (11/26/2012)

    Jeff Moden (11/26/2012)

    Michael Valentine Jones (11/25/2012)

    I think they quote most mechanical disks with a MTBF of 1 million+ hours. I have to assume that they get these numbers from the reported failure rate of large numbers of disks, but maybe they just make them up.

    Yeah... I don't believe those numbers, either. 😛

    They're statistical extrapolations. There's some science, but "mean" is "mean", not likely or expected. It means that half fail later, which implies that yours might fail tomorrow.

    Precisely. I was in the service so I definitely know what MTBF stands for (Most Troubles Begin way more Frequently :-D)... especially the ones that claim a million + hours. 😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)