What is RAID and which to use ?

  • :w00t:

    :w00t:

    Hi

    How to find on Which RAID my system or server is running

    Our is 24/7 per min there will be avg of 200- 300 transaction

    Which is Good

    • RAID 0 — striping, good performance, no redundancy

    • RAID 1 — mirroring, one-to-one redundancy

    • RAID 5 — striping with parity striped across all drives; offers performance and redundancy

    • RAID 10 — mirroring and striping; best redundancy and best performance

    • RAID 50 — parity striped across all drives in a mirrored set; redundancy and performance

    how it works ,what actually happening there

    say suppose i am inserting a value where it is going how it get stored in disk in which manner :w00t: :w00t:

    Thanks

    Parthi

    Thanks
    Parthi

  • A few things to look at

    http://en.wikipedia.org/wiki/Nested_RAID_levels

    http://en.wikipedia.org/wiki/Standard_RAID_levels

    For databases, RAID 10 would be better than 5. Anything less than 5 is commonly not considered as redundancy.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

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