Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
SQL Server 2019 on PowerEdge R640 vSAN Ready Nodes: Using VMware vSAN 7 and Red Hat Enterprise Linux 8
Executive summary Solution components overview Solution design and overview Scalability tests for SQL Server 2019 Conclusion
Conclusion
Key takeaways
Appendix A

Conclusion

Home > Integrated Products > vSAN Ready Nodes > White Papers > SQL Server 2019 on PowerEdge R640 vSAN Ready Nodes: Using VMware vSAN 7 and Red Hat Enterprise Linux 8 > Conclusion

Conclusion

  • 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:

    • For eight VMs running SQL Server 2019 in parallel, TPM values cumulatively scaled to 7.42 times showcasing near linear scale.
    • For eight VMs running SQL Server 2019 in parallel, NOPM values cumulatively scaled to 7.43 times showcasing near linear scale.
    • For eight VMs running SQL Server 2019 in parallel, batch requests per second values cumulatively scaled to 8.41 times showcasing near linear scale.
      • For eight VMs running SQL Server 2019 in parallel, IOPs values cumulatively scaled to 7.61 times showcasing near linear scale.
      • Our testing showcased vSAN’s capability to support scale and performance needs of SQL Server 2019.