Hyper-V and SQL Server 2008 R2 Raid Configuration
Posted on 2010-11-08
1. Virtualize old servers to eliminate some hardware and reduce power usage.
2. Allow us to move VHD's for redundancy reasons.
3. Allow us to upgrade servers in the future without reinstalling each server.
4. Upgrade SQL Server 2000 to SQL Server 2008.
We just picked up another Dell 2950 server. We currently have 3 old 4U sized servers we would like to turn into VM's. The first server (Server1) is a file server (primarily for archiving), Server2 is serving a proprietary network app, and Server3 is a SQL Server, and Server4 is a AD, DNS, and Anti-Virus, and Print server. All of which have very low-overhead with the exception of Server3 (SQL).
More on our environment:
1. 25 Users
2. Servers and power users are on Gigabit LAN.
3. Intranet and proprietary net app our very dependent on SQL
1. Dual Xeon Quad core
2. 16GB RAM
3. Qty. 6 - 146GB 15K SAS Drives
Our requirements is that all data is mirrored. Our current SQL Server is split across 3 RAID-1 partitions/drives, so we don't get any of the speed advantages of a parity RAID.
My first thought is setup the OS (2008 R2) on RAID 1 (2x146GB) and use the rest of the drives for my VHD's (4x 146GB) in a RAID-10.
Will this be a bottle-neck since my SQL Server won't be able to put my log files, tempdb, and data on separate partitions/drives? Should I use 3 separate RAID-1's? Or 1 large RAID-10?