Posted on behalf of Jisha J

Executive Summary

Dell™ and Microsoft®, in cooperation, provide guidelines and design 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. Dell 12th generation servers, along with the robust storage backends, form efficient candidates for a high performing data warehouse solution.

This white paper describes the architectural design principles and guidelines used to achieve an optimally balanced SQL Server Data Warehouse solution using Dell PowerEdge R720 and PowerVault MD3620i iSCSI SAN storage along with Microsoft SQL Server 2012. The performance numbers achieved for the reference configuration are also discussed in detail.