Dell and Microsoft, in cooperation, provided guidelines and design principles to assist customers in designing and implementing a balanced configuration for SQL Server data warehouse workloads to achieve “out-of-the-box” scalable performance. These database reference architectures enable each of the components in the entire 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 to achieve an optimally balanced SQL Server Data Warehouse solution according to the Microsoft Fast Track Data Warehouse 4.0 guidelines.