Technical Reviewers:Eric Hanson, Stuart Ozer, Umair Waheed, Mike Ruthruff, Thomas Kejser, Ashit Gosalia, Tamer Farag, Nicholas Dritsas, Anjan Das, Alexei Khalyako, Chris Mitchell
Version 2.0, Published November 2009
Writers:Dave Salch, Eric Kraemer, Umair Waheed, Paul Dyke
Technical Reviewers:Jose Blakeley, Stuart Ozer, Eric Hanson, Mark Theissen, Mike Ruthruff
Published: 4 February 2011
Updated: 8 January 2011
Applies to: SQL Server 2008 R2 Enterprise
Summary: This paper defines a reference configuration model (known as Fast Track Data Warehouse) using an I/O balanced approach to implementing a symmetric multiprocessor (SMP)-based SQL Server data warehouse with proven performance and scalability expectations for data warehouse workloads. The goal of a Fast Track Data Warehouse reference configuration is to achieve a cost-effective balance between SQL Server data processing capability and realized component hardware throughput.