Suggest RAID arrays for minimal single server?

  • ipgsql

    SSC Enthusiast

    Points: 185

    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: 233678

    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] 😉

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

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