Solved

SQL Server 2012 failover cluster deployment and configuration for VMware

Posted on 2014-12-19
6
471 Views
Last Modified: 2014-12-21
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
0
Comment
Question by:Jerry Seinfield
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 120

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 40509816
You will need this document to setup Clustering on VMware vSphere (same doc for all 5.x versions)

the followng document by fellow vExpert Derek is the best, and is applicable to VMware, SQL and WIndows

SQL 2012 Failover Cluster


Setup for Failover Clustering and Microsoft Cluster Service - ESXi 5.0/vCenter Server 5.0

Cluster Build Step by Step
0
 

Author Comment

by:Jerry Seinfield
ID: 40509965
Thanks Andrew,

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?
0
 
LVL 120
ID: 40510014
SQL performance in a hypervisor can be poor compared to a physical computer.
0
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 

Author Comment

by:Jerry Seinfield
ID: 40510033
Anything else?
0
 
LVL 120
ID: 40510069
I've answered i n your other question.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 40512403
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.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Basic to Dynamic disk 4 54
Remove () 9 34
SCOM - Service Restart 1 20
Migrate SQL 2005 DB to SQL 2016 4 18
The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question