I have previously blogged about Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference Architecture and Appliances). That was version 3.0 of the reference configuration that was for SQL Server 2008 R2. Just released is version 4.0 for SQL Server 2012 (download).
The following table provides a list of notable changes or updates:
Description | Version | Note |
SQL Server 2012 | 4.0 | Links to other SQL Server Best Practices documents |
SQL Server 2012 | 4.0 | Benchmarking and validation |
SQL Server 2012 | 4.0 | Memory requirements |
SQL Server 2012 | 4.0 | xVelocity memory-optimized columnstore indexes |
SQL Server 2012 | 4.0 | Solid state storage |
SQL Server 2012 | 4.0 | Validation and columnstore indexes |
SQL Server 2012 | 4.0 | Validation of baseline I/O |
More Info:
SQLAuthority News – Fast Track Data Warehouse Reference Guide for SQL Server 2012