Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dewacorp.alliances
452 Posts |
 Posted - 2007-07-29 : 06:20:48
|
| Hi anyoneWe've implemented VMWare ESX (virtual machine) on our organisation and we might implement for SQL Server in term of DEV (development) and UAT (testing).Any thought implementing this on PRODUCTION? The PRE-SALES guys from VMWare said it's ok BUT personally I'm not really convince on this? Anyone?Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-07-29 : 16:22:11
|
| I'm not a guru but we've recently had this type of proposal as wellvmware is good for managing resources and allocation is somewhat dynamic with flexible support on high availabilityBut since it is virtual and if the base layer crashes or something happens to it, then all the servers created on top of it gets affected. Not to mention you get narrowed traffic since the network interfaces are controlled by the base NICit's pretty impressive when they discuss it but you should try it out, like a POC and load/stress test it with production-like load, you should check the upcoming version, end of this year I think where the load on one VM can be distributed on other VMs--------------------keeping it simple... |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-29 : 22:29:52
|
| I'll not put production sql server on it. |
|
|
|
uberman
Posting Yak Master
159 Posts |
Posted - 2007-07-30 : 04:00:18
|
| Don't do it. Or if you do do it, test the performace first. I have worked with people who were also assured it would be fine in production, but the brand spanking new server that was VM'd up performed worse than the machine it replaced... wont go into all the details but VM and the supplying company couldnt help further and testing the box and assoiciated configuration with sqliostress and similar tools pointed up VM as being the problem.The box is now running without it... although it is the active node in an active/passive cluster with the passive node existing on bit of VMware... what jolly fun that all was! |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2007-07-30 : 16:26:46
|
Hi JenCan you tell more about POC and load/stress test?Thanksquote:
Originally posted by jen
I'm not a guru but we've recently had this type of proposal as wellvmware is good for managing resources and allocation is somewhat dynamic with flexible support on high availabilityBut since it is virtual and if the base layer crashes or something happens to it, then all the servers created on top of it gets affected. Not to mention you get narrowed traffic since the network interfaces are controlled by the base NICit's pretty impressive when they discuss it but you should try it out, like a POC and load/stress test it with production-like load, you should check the upcoming version, end of this year I think where the load on one VM can be distributed on other VMs--------------------keeping it simple...
|
|
|
|
|
|
|
SQL Server and VMWare