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

Summary 10 Summary Dell EMC, in partnership with Microsoft, enables customers to deploy tested and validated data warehouse solutions using Data Warehouse Fast Track reference architectures for SQL Server 2017. These uniquely designed architectures ensure optimal business intelligence solutions. The end-to-end best practices and recommendations enable the customer to achieve enhanced return on investment and faster time to value with a balanced data warehouse environment that can perform better than traditional data warehouse systems. Dell EMC DWFT reference architectures provide the following benefits: • Deliver a tested and validated configuration with proven methodology and performance behavior • Deliver outstanding performance on the PowerEdge 14G server platform with blazing processor speeds and leading-edge, flash-based Dell EMC storage arrays • Achieve a balanced and optimized solution at all levels of the stack by following best practices for both hardware and software components, achieving faster time to value, and lower total cost of ownership • Avoid over provisioning of hardware resources • Offer high availability at all levels of setup (host, switches, and storage) • Offer a single point of contact and accountability for purchases, services, and support; SQL Server is available to purchase from Dell EMC worldwide • Help customers avoid the consequences of an improperly designed and configured system • Reduce future support costs by limiting solution rearchitect efforts due to scalability challenges This paper describes a reference architecture using a PowerEdge R940 server with an SC9000 storage array. By implementing Data Warehouse Fast Track for SQL Server 2017 design principles, this configuration achieved a 385TB rating. 24 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4032-RA-SQL