• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 538
  • Last Modified:

Software RAID 1 + RAID 0 on the same partitions

Hello,

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?
0
kheim2008
Asked:
kheim2008
  • 3
  • 2
  • 2
  • +2
2 Solutions
 
teomcamCommented:
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.
0
 
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
0
 
andyalderSaggar makers bottom knockerCommented:
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.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
0
 
andyalderSaggar makers bottom knockerCommented:
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.
0
 
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.
0
 
teomcamCommented:
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.
0
 
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

0
 
IanThCommented:
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
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now