VMware Inc.

10/12/2023 | News release | Distributed by Public on 10/12/2023 15:32

New Reference Architecture: Microsoft SQL Server on VMware vSAN ESA

In today's data-driven business landscape, the need for robust and dependable database solutions has never been more critical. Microsoft SQL Server has long been the gold standard for mission-critical database workloads. However, to fully harness the power of SQL Server, requires an infrastructure that seamlessly aligns with its demands.

That's where the partnership between VMware vSAN Express Storage Architecture (ESA) and Lenovo ThinkAgile VX Series comes into play. This collaboration leverages cutting-edge hyperconverged infrastructure (HCI) driven by VMware vSAN ESA, hosted on the latest hardware platform. The result? A transformative solution designed to meet the complex needs of modern data-centric organizations.

We are excited to introduce our latest reference architecture, dedicated to running Microsoft SQL Server on VMware vSAN ESA with Lenovo ThinkAgile VX Series. This reference architecture is not just a document, it's your roadmap to unlocking the full potential of SQL Server in the data-driven era. Join us as we delve into the workings of this solution and explore how it can elevate your SQL Server deployment to new heights of performance, scalability, and reliability.

The Evolution: VMware vSAN 8 and vSAN ESA

VMware vSAN 8 introduced a groundbreaking solution, VMware vSAN Express Storage Architecture (ESA). This next-generation HCI software harnesses the power of high-performance NVMe-based flash drives; when combined with a new, fast and efficient data path, coupled with a resilient data structure, enables quick data storage and access. vSAN ESA provides the efficiency of RAID 5/6 erasure coding with the performance of RAID 1 mirroring, simplifying decision making and reducing costs.

Unlocking Linear Scalability, Predictable Performance, and Testing Insights

Let's explore how vSAN ESA's performs on Lenovo ThinkAgile VX Series with SQL Server workloads. In our testing, an 8-node vSAN ESA cluster on Lenovo Agile VX Series managed to produce an impressive 720,000 aggregated IOPS as the number of SQL Server VMs grew from a single VM to eight total. Further, our results showcase consistent scalability and reliable performance for SQL Server workloads. In the solution validation, you'll find various VM sizing options tailored to achieve the best performance, scalability, and capability for SQL Server workloads running on vSAN ESA.

Unleash the Full Potential of Your Applications

In today's data-centric world, the performance, high availability, and robust data protection of your Microsoft SQL Server databases are paramount. The deployment of VMware vSAN ESA on Lenovo ThinkAgile VX Series offers an unparalleled solution tailored to these critical needs.

Seize the opportunity to elevate your Microsoft SQL Server environment to new heights. Our solution architecture provides comprehensive design and sizing guidance, solution validation reports, and best practices thoughtfully curated for enterprise administrators and Microsoft SQL Server application workload owners. These invaluable resource empower you to successfully run virtualized Microsoft SQL Server workloads on VMware vSAN ESA with Lenovo ThinkAgile VX Series.

Take the next step: For a more in-depth exploration, we invite you to dive into the published reference architecture: Running Microsoft SQL Server on VMware vSAN Express Storage Architecture with Lenovo ThinkAgile VX Series. Discover the keys to unleashing the full potential of your Microsoft SQL Server databases.