Capacity Plannning

  • Hi,

    Can anybody let me know about Solid State Disk Drives.

    Thanks

  • Hmmm, your question and the title of this post seem to have nothing to do with each other.

    But OK, "Solid State Disks" is an archaic term for a physical device that appears as a disk to the system, but is actually composed of non-volatile memory chips (or volatile memory chips with some other persistent retention means).

    Technically, "USB Flash Drives" are a form of solid-state disk.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Search for reviews on Live/google. There are places that have information about what these are and how they perform.

  • Some more definition here: http://en.wikipedia.org/wiki/Solid-state_drive

    Also they are upcoming technology in Storage.. The cost was the Prime factor and the available size... but it seems to be coming down every Quarter.

  • Hak5.com has an interesting interview from a data recovery specialist Season 3 Episode 8 — Shmoocon Special March 7, 2008.

    http://www.hak5.org/episodes/season-3-episode-8-shmoocon-special

    Summed up, solid state drives have a limited life and the memory sectors will die. Data is kept at the electron level... Once they've been written to 100,000 times, they die, if a solid state drive dies, getting the data back sounded virtually impossible. So if you have solid state, make sure you have a good back up plan on something that spins. 100,000 writes sounds like a lot, but depends on how the drive is used.

  • more hype than anything else, wait a few years

    anyone know how they got around the write limit? last i heard there was a limit on the number of writes you could do on them

  • Jr.DBA (7/13/2008)


    Hi,

    Can anybody let me know about Solid State Disk Drives.

    Thanks

    1) They are AMAZINGLY fast for reads (like 3 orders of magnitude faster seek times).

    2) They are AMAZINGLY expensive, although getting cheaper pretty quickly.

    3) They do suffer from some write performance penalties.

    4) They probably will become an increasingly important storage mechanism for systems requiring the fastest IO possible. Major storage vendors are aggressively pursuing this medium.

    5) Some companies had problems with early drivers for this class of storage and got burned.

    Search the web for various benchmarks and test reports on them.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply