Reference Architecture: Microsoft SQL Server on VMware vSAN Express Storage Architecture (ESA) with ThinkAgile VX Series

This document describes the reference architecture for Microsoft SQL Server on vSAN Express Storage Architecture from VMware. The Lenovo and VMware teams worked together on the architectural vision, testing and joint engineering effort to create this Reference Architecture. This paper in intended to provide the planning, design considerations, and best practices for implementing Microsoft SQL Server on VMware vSAN Express Storage Architecture with Lenovo products.

1. Introduction
2. Business problem and business value
   1. Business problem
   2. Business value
3. Architectural overview
4. Component model
   1. VMware vSphere
   2. VMware vSAN Express Storage Architecture
   3. Lenovo ThinkAgile VX Series
   4. Microsoft SQL Server 2022
5. Deployment considerations
   1. Hardware resources
   2. Software resources
   3. Network configuration
   4. Storage Configuration
   5. SQL Server HA considerations
   6. Best practices
6. Solution validation
   1. Monitoring tools
   2. Database workload generation tool
   3. Scale-up OLTP workload test
   4. Scale-out OLTP workload test
   5. SQL Server data protection and snapshot test
7. Conclusion
8. Appendix: Lenovo Bill of materials

Resources

Document history

Trademarks and special notices