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:

  • Accelerated data warehouse projects with pre-tested hardware and SQL Server configurations.
  • Reduced hardware and maintenance costs by purchasing the right balanced hardware solution and optimizing it for a data warehouse workload.
  • Reduced planning and setup costs leveraging the Certified Reference Architecture configurations.
  • Predictable performance by configuring the system correctly and taking advantage of the tuning directions.