Design of a High‑Availability Private Cloud Architecture for SQL Server Using Windows Server 2012 R2 Technologies

Background Most internet‑scale deployments use MySQL on LAMP stacks, while SQL Server‑based high‑availability solutions are rare and typically rely on SAN clusters. With the rise of public, private, and hybrid clouds, applying virtualization and private‑cloud technologies to SQL Server becomes a valuable research topic.

Design Overview Initial attempts to use OpenStack for Windows VMs proved unsuitable due to limited Windows support and I/O performance concerns. The final design adopts native Microsoft technologies on Windows Server 2012 R2, forming a four‑layer architecture: application layer (Hyper‑V virtualization with clustering), file‑system layer (SOFS with SMB 3.0), storage‑space layer (Windows Storage Spaces), and the physical hardware layer.

Core Technologies

SMB 3.0 : Provides high‑performance, distributed file sharing with features such as clustered support, transparent failover, RDMA acceleration, and multi‑channel bandwidth aggregation.

WSS (Windows Storage Spaces) : Virtualizes SAS/SATA disks into storage pools, offering high‑availability options (single, dual/triple mirror, RAID‑5 parity) and policy‑driven tiered storage.

SOFS (Scale‑Out File Server) : Delivers highly available, scalable shared storage for Hyper‑V and SQL Server workloads, deployed in an active‑active cluster with automatic client redirection.

Private‑Cloud Implementation The solution uses JBOD enclosures, dual‑node SOFS servers with SSDs and CSV Cache, 10‑GbE switches for redundant networking, and multiple Hyper‑V hosts. Extensive fault‑injection testing confirmed high availability, while SMB 3.0 multi‑channel, RDMA, and SSD caching delivered IOPS sufficient for SQL Server’s intensive I/O demands. The architecture scales horizontally by adding Hyper‑V hosts or SOFS nodes, and offers lower long‑term costs compared to traditional SAN solutions.

SQL Server Support SQL Server instances run on Hyper‑V VMs, with database files stored on SOFS‑backed virtual disks. The combined high availability of Hyper‑V clustering and SOFS ensures overall database resilience; the deployment currently supports over 20 SQL Server instances totaling more than 10 TB of data.

Outlook Windows Server 2016 further enhances these capabilities with hyper‑converged features, suggesting even more efficient private‑cloud and high‑availability designs for future projects.