SQL Server 2012 failover cluster deployment and configuration for VMware
Hello Experts,
I need to find a step-by-step document to build a Windows 2012 R2 failover cluster for SQL 2012 server using Virtual machines in VMware.
My environment is below:
Site 1: 2 VMs deployed in a Windows 2012 cluster accessing a Primary Database
Site 2: 1 VM standalone with a Secondary database[it will be a replica of primary DB] this is for DR purposes
Can someone include best practices deployment and configuration docs for SQL 2012 R2 cluster in Vsphere 5?
Please provide all options from SQL, VMware, and Windows point of view. Consider all options virtual RDM disk, and any other technology under VMware virtual space
Blogs, steps by steps with tons of screenshots to build the Windows 2012 failover cluster
Regards
I need to find a step-by-step document to build a Windows 2012 R2 failover cluster for SQL 2012 server using Virtual machines in VMware.
My environment is below:
Site 1: 2 VMs deployed in a Windows 2012 cluster accessing a Primary Database
Site 2: 1 VM standalone with a Secondary database[it will be a replica of primary DB] this is for DR purposes
Can someone include best practices deployment and configuration docs for SQL 2012 R2 cluster in Vsphere 5?
Please provide all options from SQL, VMware, and Windows point of view. Consider all options virtual RDM disk, and any other technology under VMware virtual space
Blogs, steps by steps with tons of screenshots to build the Windows 2012 failover cluster
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL performance in a hypervisor can be poor compared to a physical computer.
ASKER
Anything else?
I've answered i n your other question.
As a good friend of mine puts it, the best virtualization of SQL Server is SQL Server. I have 2 SQL Server Boxes hosting more than 1400 applications under GeoClustered AwaysOn Availability groups. they run and consolidate database applications better (better performance, better failover, better architecture) than any other solution one could think of using clustering or virtualization.
Virtualizing SQL Server make sense only for few SQL applications and only with low throughput requirements.
Virtualizing SQL Server make sense only for few SQL applications and only with low throughput requirements.
ASKER
PROS and CONS?
What about requirements?
From your experience, can you please provide your thoughts building a windows failover cluster for SQL? Any gotchas? Do you have a comparison graph that can be used to compare SQL server cluster, AlwaysON, Mirroring on VMware?