Suggest RAID arrays for minimal single server?

• ipgsql

  SSC Enthusiast

  Points: 185

  January 24, 2013 at 11:15 am

  #269468

  Hi,

  Looking for some opinions/links. If a SQL server (OLTP) is restricted to a single box with max 8 drives, would four RAID1 arrays (OS,TEMPDB,LOGS,DATA) be the way to go?

  Or a RAID1 for OS and a 6 disk RAID10 for the rest?

  Or RAID1 OS, RAID1 TEMPDB, RAID10 for the rest?

  Thanks

• Perry Whittle

  SSC Guru

  Points: 233772

  January 25, 2013 at 2:58 am

  #1580894

  ipgsql (1/24/2013)

  ---

  Hi,

  Looking for some opinions/links. If a SQL server (OLTP) is restricted to a single box with max 8 drives, would four RAID1 arrays (OS,TEMPDB,LOGS,DATA) be the way to go?

  Or a RAID1 for OS and a 6 disk RAID10 for the rest?

  Or RAID1 OS, RAID1 TEMPDB, RAID10 for the rest?

  Thanks

  The first item to separate wpuld be the transaction logs. So more like this

  RAID1 OS, RAID1 LOGS, RAID10 for the rest

  -----------------------------------------------------------------------------------------------------------

  [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉