• Article

 

 

 

 

 

 

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.