Question
-
Topic
-
Which should I use VMware Server v2 or Hyper-V on my Windows 2008 R2 (x64)?
LockedHello,
We have two host servers running VMware Server 2 in our small office with about 10 VM’s running on both.
One of the VM’s is a sql server database (2005) running in a Win2003 guest. It’s been working pretty well (I know…running SQL server in VMware Server 2 on one spindle is probably a very bad idea) but I have an opportunity to move this VM to a new server we’ve recently inherited.
None of our other Host Servers are able to run Hyper-v (which is one reason we have stuck with VMware Server 2), but this new host server has Windows 2008 Standard r2 (x64) installed and I can enable the role for Hyper-v. My thoughts are to create a new VM in Hyper-v and move our SQL database to this new Host server.
A few specs on the new host server that should help SQL sever running a VM.
It has 3 raid arrays:
– Raid 1 (Sata drives) for the Host O/S
– Raid 10 (SAS 10k drives). I would use this to store the vm.
– Raid 1 (SAS 10k drives). I would use this to create a new empty virtual harddrive to hold the temp db and/or log files (to keep the sql parts on different spindles).Other things I need to consider:
Our host server needs to have a GUI (which I know is not ideal) so that rules out ESXi and Windows 2008 Core running Hyper-v.My question is…would I see a huge performance gain in running our SQL server VM on the new server using Hyper-v or should I just install VMware Server 2 on the new host and move my VM to the new server? Bearing in mind that either using Hyper-v or VMware Server 2 I would spilt the temp database and/or log files to a different spindle which by itself would also generate a performance increase as well.
The reason I question this is because we use VMware Server 2 exclusively on our other host servers. If we were to use Hyper-v and something happened to that host server we couldn’t just quickly move the vm to another host and get back up and running again. If the performance increase would be really noticeable using Hyper-v then I would consider going down that road, but if just using the new server (faster drives and all) and splitting the database also gives just as much or nearly the same performance benefit (and security to move the vm to another host if required) then I’m thinking it’s easier to stay with VMware Server 2.
Thoughts?
Thank you,