White Papers

Overview
4 Deploying the 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using
Dell EMC PowerEdge R940 and SC9000 | 4033-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 385TB Data
Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge
R940 and SC9000, available on the SC Series technical documents page. This guide also covers
requirements for preparing the hardware platform and provisioning the OS to achieve a balanced, optimized
385TB configuration for a Microsoft SQL Server 2017 data warehouse by using Dell EMC™ PowerEdge™
R940 servers, Dell EMC SC9000 storage arrays, and Microsoft Data Warehouse Fast Track (DWFT)
principles.
Dell EMC
PowerEdge R940
Brocade 6505
2 x Dell EMC SC9000
Brocade 65 05
23
19
22
18
21
17
20
16
15
11
14
10
13
9
12
8
7
3
6
2
5
1
4
0
0 231 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
2 x Dell Storage SC420
Public
Network
Brocade 65 05
23
19
22
18
21
17
20
16
15
11
14
10
13
9
12
8
7
3
6
2
5
1
4
0
0 231 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Public
network
Brocade 6505
Single-server reference architecture
Note: The 385TB solution includes both a single-server configuration and a highly available (HA)
configuration. For simplicity, this guide only covers the single-server implementation.