Which Raid?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • JJ
    #1

    Which Raid?

    Hi,
    I was going to buy a server with Raid 1 as I thought that it meant that if
    one of the two mirrored drives fail, you simply take it out and put a new
    one in. At which point presumably the hardware takes over and copies the
    other drive over to mirror it again.

    However, my sql server admin book, says raid 1 is bad, as it means you have
    lots of downtime, when recovering from a broken drive.

    Can anyone give me some advice on this? What is the best Raid to use when
    you are running SQL server on the server.

    Thanks

    JJ


    Tags: None
    • Dan Guzman
      #2
      Re: Which Raid?

      > I was going to buy a server with Raid 1 as I thought that it meant that if[color=blue]
      > one of the two mirrored drives fail, you simply take it out and put a new
      > one in. At which point presumably the hardware takes over and copies the
      > other drive over to mirror it again.[/color]

      This is correct. You won't have any downtime if the disks are hot-swappable
      and the mirror can be rebuilt while the other is online.
      [color=blue]
      > What is the best Raid to use when
      > you are running SQL server on the server.[/color]

      The best RAID for both fault-tolerance and performance is RAID 10. This
      combines mirroring with striping and you can use this when you have 4 or
      more drives. The downside to RAID 10 is the additional disk cost since you
      need to add 2 physical drives for 1 drive of usable capacity.

      --
      Hope this helps.

      Dan Guzman
      SQL Server MVP

      "JJ" <nospam> wrote in message
      news:40a9f33e$0 $22830$cc9e4d1f @news.dial.pipe x.com...[color=blue]
      > Hi,
      > I was going to buy a server with Raid 1 as I thought that it meant that if
      > one of the two mirrored drives fail, you simply take it out and put a new
      > one in. At which point presumably the hardware takes over and copies the
      > other drive over to mirror it again.
      >
      > However, my sql server admin book, says raid 1 is bad, as it means you[/color]
      have[color=blue]
      > lots of downtime, when recovering from a broken drive.
      >
      > Can anyone give me some advice on this? What is the best Raid to use when
      > you are running SQL server on the server.
      >
      > Thanks
      >
      > JJ
      >
      >[/color]


        Comment

        Previous template Next
        Working...