• Option 2 seems to say "build a 4 disk RAID 1+0 array and then sub-divide into partitions"? If that is that correct then I would never recommend it!

    I'll give you an option 3 if I may:

    Disk 1 RAID 1 OS + SQL installation

    Disk 2 No RAID Temp DB

    Disk 3 RAID 1 Data

    Disk 4 RAID 1 Log

    Spare Disk - Warm Standby disk for any failed unit.

    This exposes you to marginally more risk in that the loss of the drive supporting tempdb will force a shutdown of SQL, but if any other disk fails then the array can be rebuilt automatically using the warm standby disk.

    Remember - Tempdb is recreated from new every time the SQL is re-started.

    Ultimately, you haven't really got enough spindles here to make this really effective. Another 2 spindles would mean that you could make Disk 2 RAID 1+0.

    There isn't much point making the Log disk RAID 1+0 as this is essentially written sequentially and a single spindle does this very effectively.