Hello all. I wish to solicit some comments based on our situation concerning database servers on VM's.
+ CURRENTLY: +We have been running an ESX blade system for about 4 years now, upgraded to vi3 last summer. These boxes are not beasts either, they are simple dual CPU with Hyperthreading or dual dual cores. They have been running Oracle and SQL servers the whole time. On a whole, the peformance has been good with a few solvable problems. Occaisionally we had some issues that required us to give more resources or shares to the servers. We do have 2G Fiber Channel on the Disk subsystem.
We built a new blade system to grow on (we are still keeping the old system) with dual quad core CPU's and twice the RAM as before (14GB). I am assuming that doubling the power should be a nice step up. My only wish is that I had a FC back end, but my boss wants to go iSCSI for cost savings, and for the most part it works good, I am only nervous because the 1g vs 2g throughput.
+ SITUATION: +We have some new database servers to build. Plans are to virtualize them as we did the others. Base VM will be on the order of 4vcpu, 6G RAM and probably only share the ESX host with a few (2-5) lower resource requiring vm's. Our older setup was 2vcpu and 4G RAM, and I considered this fairly sucessful. *However*, everytime we sit down with a vendor or have some kind of performance issue with a support person we get an earful that they don't like virtualization because its too slow. I end up trying to explain to them we have run fairly successfully for several years. Granted you should take a slight performance hit, but it is worth it when you consider other advantages. Its alwasy the same, general comments, no hard data, and stories of another customer who had a nightmare.
PS, I know FC has always been considered faster, but I am going to be stuck with iSCSI solution on the new blades :-(. So far though, I have not had any real problems, but my production db's are not installed yet.
WHAT I NEED: I am working with our DB guy to work out some way of getting some hard benchmark numbers to see the bottom line, but I would like to know what others think of using databases on VM's and what their experiences are. THANKS!!