sql 2008 cluster vmware

would like to build a sql 2008 cluster in vmware environment

1... need high availability and processing power, sql is verry high utillized and i mean verry high millons of transactions a day
2...need failover
3....budget is huge for this, so not a issue in that regard

need some advice\sujestions from the guru's out there
what do you gents sujest i go about this

dano992Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Paul SolovyovskyConnect With a Mentor Senior IT AdvisorCommented:
For a high IOPS SQL system the current version of VMWAre may not be the best solution.  The new vSphere 4.0 will be much better for SQL but even then I would hesitate to put such a system into a virtual environment..and I try to virtualize anything I can normally.

If you would like to do this anyway I would wait for vSphere 4.0, ensure that you configure either FT (Fault Tolerence) or a Microsoft Cluster (create a rule that prevents both nodes to be on the same  host).  Since current VMWare HA is not insteneous failvoer the MS cluster should do the job in a virtual environment.

My $.02
0
 
vmwarun - ArunCommented:
Do you have SAN in you environment ?
0
 
dano992Author Commented:
yes there is going to be a SAN
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
dano992Author Commented:
what would be the point of creating a multi-node sql cluster in VMware (HA)?
since vmware provides high availability.
can someone give some insite on how vmware (HA) and mulit-node sql cluster work together?
assuming the sql servers are virtual servers
0
 
Paul SolovyovskySenior IT AdvisorCommented:
HA availability in current version of VMWare is not the same as a Microsoft Cluster.  If a virtual machine fails it will start on a different host in the cluster after it is done rebooting on it.  There is essentially some downtime, albeit not a lot but in a high transaction environment you would be done for a few minutes.

With a Microsoft Clustering you have realtime failover.  The advantage of MS Clustering in VMWare with HA is that if the SQL doesn't require all the resources on the hardware you can use the remaining resources for other VMs and you can change and upgrade virtual hardware on the fly (one node at a time)
0
 
dano992Author Commented:
could you have 2 3 nodes each sql cluster in vmware environment?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.