SQL Server Performance


Discussion in 'Getting Started' started by RVG, Jan 25, 2010.

  1. RVG Member

    Why RAID 10 is better for SQL server?
    Though I'm able to find the advantages of RAID 10 over the other RAID levels but could not find why especially RAID 10 is better for SQL server. More over the cost of the RAID 10 is more expensive when compared to other RAID levels.
    Can anyone explain me this please.
    Thanks & Regards,
    Ravi Varma
  2. Luis Martin Moderator

    Please, write "raid 10" in search area and you will find a lot of information.
  3. bpman New Member

    RAID10 is a mirrored stripe. This means there are no parity calculations (like r5) and potentially many spindles for good throughput and being mirrored each disk is redundant.
  4. preethi Member

    "RAID 10 provides the performance benefits of disk striping withthe disk redundancy of mirroring. RAID 10 provides the highestread-and-write performance of any one of the other RAID levels, but atthe expense of using two times as many disks."
    Read Here: http://msdn.microsoft.com/en-us/library/ms190764.aspx
    Just Google on "Raid 10 on SQL Server", you can get many articles on how they improve performance.
    You need to make sure what level of performance you need and whether you can go with the the price tag attached to RAID 10.

Share This Page