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

  • November 25, 2012 at 7:20 am

    #1562041

    Michael Valentine Jones (11/24/2012)

    The 400 GB drive on this link is rated a 35 PB of lifetime writes, so that would mean you could write 1 TB of data on it each day for 98 years, or 20 TB per day for 5 years.

    Gosh. That seems almost like nothing. Our main database only has 80GB but the legacy code has some pretty bad problems and easily writes several TB a day. Of course, we're working on fixing all of that but I'm sure that larger systems have similar problems and could easily reach 20TB per day especially on TempDB.

    --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)