The Dell EMC Ready Solution for Microsoft SQL Server 2017 with Microsoft Storage Spaces Direct (S2D) is a validated solution for your database ecosystem. Many customers face the challenge of migrating and upgrading legacy versions of SQL Server to a modern cost‑optimized solution that has the performance, reliability, and resiliency for databases. In this design guide, we detail how a 4- to 16-node S2D cluster in a hyper-converged architecture can be the consolidation platform for your SQL Server databases.
At the foundation of the S2D solution are Dell EMC PowerEdge 14th generation servers with all-flash storage. Each server is a performance-based building block that is preconfigured with S2D, allowing modular expansion. The minimum configuration for the Ready Solution is four servers, which provide the resiliency to survive two planned SQL virtual machine (VM) failures without affecting database availability. The modular design enables a cost-optimized entry point for the solution and enables you to incrementally grow the S2D cluster by adding nodes.
Dell EMC Engineering tested and validated the S2D cluster by running a step-stress test. We ran from one to eight virtualized databases on the storage cluster, incrementally adding more load and achieving near-linear scalability.
To provide a comprehensive platform that includes database backup and recovery, we integrated the Dell EMC Data Domain DD6300 system with Data Domain Boost for Enterprise Applications (DDBEA). In our testing, the Data Domain system was able to back up a 431 GB database in 3.8 minutes and restore the same database in 9.25 minutes.
The Ready Solution for Microsoft SQL Server with S2D nodes is a comprehensive solution that provides performance, resiliency, and protection for databases. It is also a cost-optimized database solution with a starting configuration of four S2D nodes, providing a low-investment entry point.