White Papers
Table Of Contents
- 1 Microsoft SQL Server 2017: Data warehousing with improved column-store technology
- 2 Recommended reference architectures
- 3 Hardware components
- 4 Storage configuration
- 5 Server configuration
- 6 Windows Server 2016 configuration
- 7 SQL Server 2017 Enterprise Edition configuration
- 8 Additional considerations for the highly available reference architecture
- 9 DWFT for SQL Server 2017 certification
- 10 Summary
- A Technical support and resources
Recommended reference architectures
6 65TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC
PowerEdge R640 and Dell EMC PowerVault ME4024 | 3918-RA-SQL
2 Recommended reference architectures
The following subsections describe the two different DWFT reference architectures for SQL Server 2017,
comprised of PowerEdge R640 servers and PowerVault ME4024 arrays.
2.1 Single-server reference architecture
Figure 1 illustrates the single-server reference architecture with its major elements and Table 1 lists the
component details.
Single-server reference architecture