SQL Server Technical Article
Version 3.0.8, Final 2/1/2011
Writers: Eric Kraemer, Mike Bassett
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.
To review the document, please download the Fast Track Data Warehouse 3.0 Reference Guide Word document.