vSAN

Announcing Microsoft SQL Server Big Data Clusters on VMware Tanzu Kubernetes Grid

VMware Tanzu, a family of products and services for modernizing applications and infrastructure, enables our customers to deliver better software to production continuously. VMware Tanzu helps build cloud native apps, refactor existing apps and allow customers to run and manage Kubernetes across multiple clouds, teams, and clusters.

Today we are announcing the joint solution efforts of running Microsoft SQL Server Big Data Clusters on VMware Tanzu Kubernetes Grid. It offers a compelling new way to utilize SQL Server to bring high-value relational data and high-volume big data together on a unified, scalable data platform managed by the VMware Tanzu portfolio.

With the SQL Server Big Data Clusters (BDC) CU12 release, Microsoft no longer places restrictions on the selection of Kubernetes platform to run BDC on top. Now BDC can run on any Kubernetes stacked based on version 1.13 and higher. Microsoft provides support for BDC itself as a workload, while VMware provides support for the Tanzu Kubernetes Grid as the Kubernetes runtime. For more details, please see BDC CU12 platform release notes.

VMware Tanzu Kubernetes Grid (TKG) provides a consistent, upstream-compatible implementation of Kubernetes, that is tested, signed, and supported by VMware. With the BDC on Tanzu partner solution published here, Tanzu Kubernetes Grid can provide BDC customers with consistent Kubernetes everywhere, automated multi-cluster operations, validated integrated services, and Enterprise-wide management experience.

This joint partner solution also validates the Spark SQL TPC-DS-like benchmark of running BDC on TKG with a four-node VxRail Cluster. The solution architecture diagram is designed as follows:

Microsoft SQL Server Big Data Clusters on VMware TKG

The validation results demonstrate a linear scalable performance in terms of Spark SQL TPC-DS-like benchmark for different scale factors of dataset size (1TB, 3TB, 10TB, and up to 30TB).

Microsoft SQL Server Big Data Clusters on VMware TKG

Related links:

BDC Partner page: https://docs.microsoft.com/en-us/sql/sql-server/partner-big-data-cluster?view=sql-server-ver15

BDC CU12 Release Notes: https://docs.microsoft.com/en-us/sql/big-data-cluster/release-notes-big-data-cluster?view=sql-server-ver15

Reference Architecture: https://core.vmware.com/resource/running-microsoft-sql-server-big-data-clusters-vmware-tanzu-kubernetes-grid#