SQL 2008 R2 disk configuration on Hyper V Server R2
Posted on 2011-05-02
Hi we are planning on virtualizing a line of business application that runs SQl as the back end on Hyper-V Server 2008 R2 and use either SCE or SCVMM to manage it. Overall, this application now is run on 4 physical machines. 3 out of the 4 server functions are pretty small and don't use alot of the server resources.
However, I know that SQL is one of the applications that alot of people aren't comfortable virtualizing. The server we are putting this on is a pretty powerful machine, which I hope will overcome the overhead that is associated with virtualizing.
Dell R510, dual xeon processors
2 146 gig 15K SAS drives - Mirror Hyper V Server
2 146 gig 15K SAS drives - Mirror (?? normally if this was a physical implementation I would put SQL Logs here)
3 146 gig 15K SAS drives - RAID 5: VHD FIles for all 4 VM's
So my question is about the disk configuration? For SQL, do people create separate VHD files for the logs and the SQL instance in addition to the VHD for the OS, and put them all on different spindles? In our case, I think we want to stick with fixed sized VHD's if possible rather than pass through.
Thanks in advance!