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

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.

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

Fast Track database component architecture

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.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s