Perry Whittle (1/19/2011)
alen teplitsky (1/19/2011)
another plus is that windows clusters are a pain in the *** and changing minor things like IP's can break them.changing the IP for what a clustered resource or for the Windows cluster itself?
alen teplitsky (1/19/2011)
no need for clusters on vmwaremany organisations use both with great success, but i get what you're saying
i think it was for the cluster. did it a few years ago in testing and it broke the cluster. took me hours to figure it out by searching the registry. apparently when you change it in the cluster GUI it won't take in the registry or something like that. maybe it was the NIC IP's on the hosts. don't remember all the details.
and one other point, adding new drives to a cluster is another pain in the *****. you have to take the entire instance down to add a new drive
either way i think that SQL on vmware is OK if you run a lot of small databases with minimum I/O. but where i work we have some databases in the hundreds of GB where some queries select 5-10 GB of data. the only value with vmware in this case is to run it on a single instance/node just for the failover capability