Dell 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.
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 Compellent SC8000 storage arrays along with Microsoft SQL Server 2012.
The objective behind the database Fast Track reference architectures is to provide tested and validated configurations and associated resources to help customers identify the right architecture and configuration for data warehouse solutions. The following are tangible benefits of following these recommended configuration best practices and guidelines: