Solved

What are PROS and CONS of building a Windows failover 2012 cluster for SQL  2012 DBs in VMWARE?

Posted on 2014-12-19
3
674 Views
Last Modified: 2014-12-19
Hello VMware experts,

What are the PROS and CONS of building a Windows fail-over cluster 2012 for SQL DBs in a VMWARE space? Requirements?
is virtual RDM disk the only option? what is required to fully implement? Easy to deploy and maintain? what about the number of SQL licenses required?

If we need also to replicate that DB from primary DB to DR site, should be use SQL Mirroring  or any other technology?

Please advice
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
  • 2
3 Comments
 
LVL 120
ID: 40510012
The advantages and disadvantages are the same for any VM.

1. RDM disks

or

2. Microsoft iSCSI disk in the VM

You will need the same licenses as per physical machines.

You can use SQL Mirroring, or VM replication.
0
 

Author Comment

by:Jerry Seinfield
ID: 40510104
If I want to use a Windows 2012 failover cluster across VMware hosts, meaning one VM on a physical hosts, and another VM into another physical host, accesing a shared storage,

Is RDM my only option? if so, how many NICs, I need for each physical host to complete the cluster [2 node across hosts]

Any other option rather than RDM disks?

Can you please elaborate in your sentece You will need the same licenses as per physical machines?

Because I will be deploying a WIndows 2012 failover clustering for SQL databases, what license is required for the OS? Standard would be enought or need a higher one

If we decide to implement SQL Always ON, which also requires WSFC, can we implement on WIndows 2012 standard edition as well? what about the SQL licensing?


Please, your feedback is highly appreciated
0
 
LVL 120

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 40510129
You must have shared storage to complete a Failover Cluster - RDM presented to ESXi hosts satisfies this Fail,over cluster requirement.

As for network interfaces for the hosts, these should already be in place for your VM Cluster.

Windows 2012 Standard supports Failover Clustering.

The SQL licensing Guide is here

http://download.microsoft.com/download/C/3/7/C37F243B-0246-493E-ABFC-41A7FFD6DE38/SQL_Server_2012_Virtualization_Licensing_Guide.pdf
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ARP not working as expected 11 80
The location of vCenter certificate file ( SSL\cacert.pem) 2 42
SQL Simple Query Taking a Very Long Time 11 37
SQL query 45 41
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

751 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