Solved

SQL Server 2012 failover cluster deployment and configuration for VMware

Posted on 2014-12-19
6
476 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 121

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 121
ID: 40510014
SQL performance in a hypervisor can be poor compared to a physical computer.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:Jerry Seinfield
ID: 40510033
Anything else?
0
 
LVL 121
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB. Just connect to vCenter DB(default DB should be VCDB and using…
When rebooting a vCenters 6.0 and try to connect using vSphere Client we get this issue "Invalid URL: The hostname could not parsed." When we get this error we need to do some changes in the vCenter advanced settings to fix the issue.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

688 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