Archives

SQL 2012 Cluster Storage on Hyper-V 2016

Hi,

I’m migrating from VMware to Hyper-V and have a question regarding the storage for our SQL 2012 Cluster VM’s. We would like to do a side-by-side SQL migration to retain the current SQL Failover Cluster config.

Current setup:
- 3x VMWare ESXi 5.5 hosts
- 2x Windows Server 2012 VM’s with SQL 2012 Standard
- Failover Cluster for 6x SQL 2012 Clustered Instances
- HP 3PAR Fibre Channel SAN with 17x RDM’s for Cluster Storage

New Setup:
- 3x Windows Server 2016 Hyper-V hosts
- 2x Windows Server 2012 VM’s with SQL 2012 Standard (converted from VMware)
- Failover Cluster for 6x SQL 2012 Clustered Instances (existing)
- HP 3PAR Fibre Channel SAN (1x 5TB Disk or multiple smaller disks)

Would it be supported to setup the new environment as,
- Failover Cluster for 3x Hyper-V hosts
- Add shared storage from the SAN to the Hyper-V Cluster (either 1x 5TB disk or multiple smaller disks)
- Convert disks to Cluster Shared Storage (CSV’s) ***is this supported for SQL 2012 workload??
- Convert SQL VM’s from VMware to Hyper-V (retaining existing failover cluster config for SQL)
- Attached new disks to mirror previous setup in VMWare

I’ve found this link that has good info but it mentions "CSVs don’t support the Microsoft SQL Server clustered workload in SQL Server 2012 and earlier versions of SQL Server".
https://docs.microsoft.com/en-us/windows-server/failover-clustering/failover-cluster-csvs

Are we able to use CSV’s on the Hyper-V failover cluster?

Thanks!

Read full post . . . .

Go Que Newsroom Categories

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 36 bytes) in /home/content/36/8658336/html/goquecom/wp-includes/taxonomy.php on line 3363