White Papers

Overview
4 Deploying the 65TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using
Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 4023-CD-SQL
Overview
This guide provides step-by-step instructions to build a balanced configuration for a Microsoft
®
SQL Server
®
data warehouse workload, as specified in the companion reference architecture document, 65TB Data
Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge
R640 and Dell EMC PowerVault ME4024 (available on Dell.com/support). This guide also covers
requirements for preparing the hardware platform and provisioning the OS to achieve a balanced, optimized
65TB configuration for a Microsoft SQL Server 2017 data warehouse by using Dell EMC™ PowerEdge™
R640 servers, Dell EMC PowerVault™ ME4024 storage arrays, and Microsoft Data Warehouse Fast Track
(DWFT) principles.
Single-server reference architecture
Note: The 65TB solution includes both a single-server configuration and a highly available (HA) configuration.
For simplicity, this guide only covers the single-server implementation.