I have always enjoyed learning about Fast Track Data Warehousing Technology. The goal of a Fast Track Data Warehouse reference architecture is to achieve an efficient resource balance between SQL Server data processing capability and realized component hardware throughput.
Recently Fast Track Data Warehouse Reference Architecture is updated for SQL Server 2012. Here are the changes in the FT 4.0.
|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|
following are key principles of the Fast Track program:
- Workload-specific benchmarks. System design and configuration are based on real concurrent query workloads.
- Detailed and validated hardware component specifications.
- Component architecture balance between database capability and key hardware resources.
Reference: Pinal Dave (https://blog.sqlauthority.com)