SQL clustering with Virtual machines

I am setting up a SharePoint 2010 environment with two node SQL clustered database environment. I want to use virtual machines instead of physical servers for SQL server 2008 standard edition. I heard that clustering is not possible with Virtual machines. Is that true??? Does VMWare support VMs clutering or do I have go with physical boxes???

Can somebody please educate me on how it works with VMWare and which one's better??? VMs or physical boxes clustering??

Thanks in advance.
BoozTechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Not true, checkout these articles, and the Bible of Clustering for ESXi

Setup for Failover Clustering and Microsoft Cluster Service
http://www.vmware.com/pdf/vsphere4/r41/vsp_41_mscs.pdf

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1004617

These are the Clustering Guides

http://www.vmware.com/pdf/vsphere4/r41/vsp_41_mscs.pdf

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1004617

Creating a Cluster in Windows Server 2008

http://blogs.msdn.com/b/clustering/archive/2008/01/18/7151154.aspx

Installing a SQL Server 2008 R2 Failover Cluster

http://msdn.microsoft.com/en-us/library/ms179410.aspx

Getting Started with SQL Server 2008 R2 Failover Clustering

http://msdn.microsoft.com/en-us/library/ms189134.aspx

Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 1

http://www.mssqltips.com/tip.asp?tip=1687

SQL Server 2008 Failover Cluster Document from Microsoft

http://tinyurl.com/SQL2K8Cluster
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
We cluster Virtual to Virtual, Physical to Physical and Virtual to Physical!
0
BoozTechAuthor Commented:
Thanks a lot for the quick response. I will go through the links and I am sure they help me a lot. I do have some more questions though. I have both SQL VMs on the same ESX server, so what if the esx server goes down?? Is it better if they are on different esx servers??
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

jfletchsterIT ManagerCommented:
Physical or Virtual is almost irelivent, as quite often the machine is unaware of the fact that it is virtual. Agree with hanccocka, we have the same. Modern virtualisation is very stable and allows for alot more options than physical and I would nearly always recommend it over using physical.
0
BoozTechAuthor Commented:
Thanks. so going back to my previous question do you have both VMs on same esx server or different??
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
You can have both VMs on the same host, or different hosts, but for resilience you would be better with a node per  different ESX host.
0
BoozTechAuthor Commented:
Sorry, I am little confused. If I have them on same esx server and if the esx server goes down both VMs will be down too..so is my SQL environment. How the failover works in this situation???
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
That is true.

Thats why you would have your VMs on different hosts.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BoozTechAuthor Commented:
Thank you.
0
BoozTechAuthor Commented:
I just wanted to clarify one more thing. which one’s better??  

VMware’s automatic failover (High Availability services) OR MS clustering services??

Thanks for your reply in advance.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

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.