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
Executive summary
4 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
Executive summary
Dell EMC and Microsoft, in cooperation, provide guidelines and principles to assist customers in designing
and implementing a balanced configuration for Microsoft
®
SQL Server
®
data warehouse workloads to achieve
out-of-the-box scalable performance. These database reference architectures enable each of the components
in the database stack to provide optimal throughput to match the database capabilities of the specific setup.
Innovative Dell EMC™ PowerEdge™ 14th-generation (14G) servers, along with robust and cutting-edge Dell
EMC PowerVault™ ME4024 storage arrays, form efficient candidates for a high-performing data warehouse
solution.
This paper describes the design principles and guidelines used to achieve an optimally balanced 65TB Data
Warehouse Fast Track (DWFT) reference architecture for SQL Server 2017 using PowerEdge R640 servers
and PowerVault ME4024 arrays. The configuration used to achieve the performance numbers for the
reference configuration is presented in detail.
The target audience for this paper includes database administrators, business intelligence architects, storage
administrators, IT directors, and data warehousing users seeking sizing and design guidance for business
intelligence solutions with SQL Server 2017.