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
Microsoft SQL Server 2019 Big Data Cluster on Dell EMC VxRail
Executive summary
Business challenge
Solution overview
Document purpose
Audience
Terminology
We value your feedback
Design overview Use case overview Supporting software technology Dell EMC VxRail Lab validation of SQL Server 2019 Big Data Cluster Conclusion Resources Appendix A: Design architecture and component specifications

Solution overview

Solution overview

  • This solution highlights the power of implementing SQL Server 2019 Big Data Cluster technology hosted on Dell EMC VxRail hyperconverged infrastructure (HCI). In the solution use case, we integrate SQL Server 2019 RDBMS, SQL Server Big Data Cluster, MongoDB, and Oracle RDBMS to create a unified data analytics platform. SQL Server 2019 scale-out storage and compute clusters, and new data virtualization techniques are the enabling technologies. This SQL Server 2019 Big Data Cluster solution also benefits from the simplicity of a complete, yet flexible, validated Dell EMC VxRail HCI platform with Kubernetes management and storage integration.

    The solution demonstrates the combined value of the following technologies:

    • VxRail HCI (all HCI stack components—compute, storage, networking, and data protection)
    • Large tables stored on a scaled-out HDFS storage cluster that is hosted by Big Data Cluster
    • Smaller, related data tables that are hosted on SQL Server, MongoDB, and Oracle databases
    • Distributed queries that are enabled by the PolyBase capability in SQL Server 2019 to process Transact-SQL queries that access external data in SQL Server, Oracle, and MongoDB
    • VMware virtualization and management product suites with VMware Cloud Foundation hyperconverged architecture
    • VMware vSAN all-flash performance and enterprise-class storage services
    • Top-of-Rack (ToR) and out-of-band (OOB) switch integration
    • Red Hat Enterprise Linux

    With this paper, we include physical and virtual topology diagrams and general connectivity guidelines for the solution. We also provide additional design guidance that focuses on scaling, flexibility, and high availability.

    Focusing on the recommended best practices to help make your implementations successful, this white paper describes how to design and build a SQL Server Big Data Cluster solution. In addition, we explore the intersection of SQL Server Big Data Cluster and PolyBase, which supports big data workloads that connect to a larger data sphere. Our solution demonstrates a reliable and repeatable method to deploy the required analytic application services by using automation and orchestration provided by VMware vSphere, Docker, and Kubernetes.