Home > Workload Solutions > SQL Server > White Papers > Running SQL Server 2022 with Red Hat OpenShift on AMD EPYC based Dell PowerEdge servers and Dell ObjectScale > Introduction
SQL Server 2022 is the latest version of SQL Server database for Microsoft which introduces the powerful enhanced Polybase feature. The Polybase feature enables the use of T-SQL queries to join data from external sources with the data from SQL Server internal tables.
This innovative capability eliminates complex and time-consuming data transformation processes. Polybase streamlines the data integration workflows which enable leaders and stakeholders to gain valuable insights and make better business decisions.
The goal of this white paper is to provide solution insights to data engineers and architects about how the SQL Server 2022 database can be deployed in a containerized environment and how data analytics can be run against S3-compatible software-defined object storage using T-SQL.
The architecture for this solution will be based on Red Hat OpenShift Container Platform (OCP) along with Red Hat OpenShift Data Foundation (ODF) running on Dell PowerEdge servers with AMD 4th Gen EPYC 9334 processors and Dell ObjectScale storage platform.
4th Gen AMD EPYC processors™ continue the AMD history of x86 architecture innovations and world-record performance found in 3rd Gen AMD EPYC processors. Each 4th Gen AMD EPYC processor includes up to 128 cores running at high frequencies, high memory bandwidth and capacity, and up to 1152 MB of L3 cache to unleash exceptional performance, depending on the processor model.
4th Gen AMD EPYC processors are built on next-generation 5nm technology and support either 6 or 12 channels of high- performance DDR5 DIMM, AVX512, and either 128 lanes (single-socket) or up to 160 lanes (dual-socket) of fast PCIe® Gen 5 I/O. These features meet the demands of compute and memory intensive data analytics workloads.