Installing PolyBase as a scale-out group

To enhance the performance and scalability of SQL Server 2019, you can deploy PolyBase as a scale-out group. In this mode, all instances in the group operate as one when querying external data sources. Scale-out groups are particularly useful when querying large partitioned tables or big files out in Hadoop or in Azure Blob storage. Scale-out groups sub-divide and parallelize query processing across the nodes of the scale-out group, which takes full advantage of the distributed architecture.

Note

Scale-out groups are supported on the Windows operating system only. If you want to build a scale-out data virtualization platform on Linux, then use SQL Server 2019 Big Data Clusters, which is optimized for this scenario using Kubernetes. For more information on SQL Server 2019 Big Data Clusters, refer to Chapter 9, SQL Server 2019 Big Data Clusters.

Setting up a scale-out group is relatively straightforward, provided you follow a methodical...