Fast Track Data Warehouse Reference Guide for SQL Server – SQLAuthority News

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 20124.0Links to other SQL Server Best Practices documents
SQL Server 20124.0Benchmarking and validation
SQL Server 20124.0Memory requirements
SQL Server 20124.0xVelocity memory-optimized columnstore indexes
SQL Server 20124.0Solid state storage
SQL Server 20124.0Validation and columnstore indexes
SQL Server 20124.0Validation of baseline I/O


Fast Track Data Warehouse Reference Guide for SQL Server - SQLAuthority News ft40-800x453

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.

Please read the complete whitepaper over here.

You can always reach out to me on Twitter for follow-up. I have been blogging about SQL Server videos over here. If you like bite-size fun SQL videos, please do not forget to subscribe to my youtube channel.

Reference: Pinal Dave (

SQL Download, SQL White Papers
Previous Post
SQL SERVER – Working with FileTables in SQL Server 2012 – Part 3 – Retrieving Various FileTable Properties
Next Post
SQL SERVER – Introduction to Hierarchical Query using a Recursive CTE – A Primer

Related Posts

Leave a Reply