Solved

SQL Server 2012 failover cluster deployment and configuration for VMware

Posted on 2014-12-19
6
466 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
  • 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
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.

679 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