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?