There is a rapid expansion in the amount of data that is needed to be processed for OLTP workloads for the multitude of organizations today. Using vSAN deployed on Dell EMC Ready Node infrastructure, organizations can capitalize on saving costs and maintaining performance.
The biggest hurdle to adopting an HCI deployment for SQL Server ecosystems is the question whether the infrastructure can support the IO needs of a high stress OLTP environment. In our testing, we simulated the most demanding area of this ecosystem— the OLTP production databases. We also left room for the test and validation databases, and other application VMs that customers might have in their environment. During our testing, we simulated increasing each VM supporting 1 TB OLTP databases in a high stress environment from a single VM up to eight VMs. The near-linear performance seen through our tests showcases the ability of the infrastructure to keep up with the high demands of SQL Server 2019.
Using the benchmark tests showcased in this document, we can see that vSAN coupled with Dell EMC hardware is the right choice for deploying SQL Server 2019 workloads including multiple high-stress production OLTP VMs. Our testing demonstrated the ability of this solution to scale as workload increased with near linear performance. The highlights of the benchmark performance tests include: