?
Solved

SQL Server 2012 failover cluster deployment and configuration for VMware

Posted on 2014-12-19
6
Medium Priority
?
491 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 123

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 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 123
ID: 40510014
SQL performance in a hypervisor can be poor compared to a physical computer.
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 

Author Comment

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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

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.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
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…

752 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