Software RAID 1 + RAID 0 on the same partitions


I have Windows 2008 R2 machine with 2 physical HDD's.
It will work with SQL 2008

Currently there is software mirroring RAID 1 configured on 2 HDD's 1 single partition on both.

I was wondering it it makes sense to create 2 partitions:
1) RAID 1 for data
2) RAID 0 for temp / swap etc

Does it make sens when everything is still on 2 single HDD's?

Maybe also leave 2'nd partition without any software RAID?

Does anyone has experience with such scenarios?
Who is Participating?
Since you have 2 HDD, the safest way to keep your server up and running is RAID1. If you mix the software RAID with 0+1 (unlikely) again 2 HDD's overall performans will go down especially in busy times. If I were you I would not jeopardize SQL server with that gambling. I think that server also you DC, am I right? If so, just make it RAID 1. Might be slow but will be safe.
Kruno DžoićSystem EngineerCommented:
Only one RAID is enough, because you use software RAID, partitioning drive have no use, only cosmetic, because if you reinstall OS, you lose everything
It makes some sense having the tempdb, swap (and logs) on RAID 0 and the OS and data on RAID 1 in that if you lose a disk you don't lose any data although SQL stops of course if you lose one of the disks and you can't do no-loss restores. Alternatively you could use RAID 1 for data and OS and then seperate non-RAIDed partitions on the remaining space, for example D: on one disk for logs, E: on the other for tempDB.

I'd rather do the whole thing under hardware RAID 1 but that's probably not an option and it's presumably not supposed to be a high performance highly available system anyway.
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

kheim2008Author Commented:
so what about option: 2 physical HDD's

Partition 1 (Software RAID 1 on HDD1 & HDD2) - system & SQL data
Partition 2 (NonRaid on HDD1) - temp db
Partition 3 (NonRaid on HDD2) - logs
That'd be fine, if you lose one disk you've still got the OS and data on the other and it's easy enough to create new tempDB and logs folders.
kheim2008Author Commented:
Thanks, and how about performance?
Will it be better than single RAID 1 from these 2 HDD's?
I don't wish do compromise safety if no or marginal performance can be obtained.
RAID 0 will give you better performance (almost twice) but if something happens only 1 HDD you loose everything inlcuding second HDD. Because data shared and written on 2 HDD simultaneously. RAID1 speed will be equal to 1 HDD's performance but same data wll be written on 2 HDD twice. With RAID1 if you loose 1 HDD your system and data still be available and safe.
kheim2008Author Commented:
I understand the risks (I know RAID logic)
I guess my question is more about fact of software RAID on same HDD's

Again (I'm looking at software raid configured as below)

[C:    ] [D:    ]
HDD1 [RAID 1] [RAID 0]
HDD2 [RAID 1] [RAID 0]

compared to what I have now:
     [C:             ]
HDD1 [RAID 1         ]
HDD2 [RAID 1         ]

Open in new window

i use 4 drives in a raid 10 for performance and protection(a raid 1 array of raid 0 arrays)  as 2 drives can fail as long as they are in different sides of the raid array
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.