Dell PowerEdge R940 385TB Data Warehouse Fast Track Reference Architecture for - Page 5

Executive summary 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 SC9000 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 385TB Data Warehouse Fast Track (DWFT) reference architecture for SQL Server 2017 using PowerEdge R940 servers and SC9000 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. 5 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4032-RA-SQL