The goal of this SQL Server solution is to demonstrate the advantages of using SQL Server 2019 Big Data Clusters with PolyBase to create a datasphere that easily supports petabytes of data and the capability to seamlessly access other data sources to improve analytics reporting.
A Dell EMC VxFlex software-defined platform hosted our lab environment. We chose the VxFlex platform because it supports both two-layer and hyperconverged modes. The lab configuration used hyperconverged mode, which offered substantial consolidation savings. With hyperconverged mode, we can use CPU, memory, and storage resources for our containers on our VxFlex nodes; thus, less hardware is required. Another key reason for using the VxFlex infrastructure was its integration with Kubernetes. As the use case develops, we show how the VxFlex CSI plug-in provides an additional level of storage automation through Kubernetes.
The use case in this white paper describes how to manage and mine Big Data with the assistance of innovative container technologies. It demonstrates how you can use your company’s datasphere for improved analytics on an agile platform that is designed for flexibility, automation, and orchestration.