Jerry Seinfield
asked on
What are PROS and CONS of building a Windows failover 2012 cluster for SQL 2012 DBs in VMWARE?
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
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
ASKER
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
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
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.