FAST TRACK DATA WAREHOUSE FOR SQL SERVER 2012

Eric Kraemer Senior Program Manager Confidential and Proprietary © 2011 Microsoft Last Updated: Friday, April 24, 2020

AGENDA

• • • • • The Fast Track Program Fast Track Value Customer Evidence Fast Track for SQL Server 2012 Performance Fast Track for SQL Server 2012 Features

FAST TRACK DW REFERENCE ARCHITECTURES

• • • • • • • • Hardware System Design: • Tight specifications for servers, storage and networking • • Resource Balanced & Validated Latest generation Servers & Storage 3

FAST TRACK DATA WAREHOUSE BENEFITS

Pre-Balanced Architectures

Access to top industry engineering resources

Choice of HW Platforms

HP, Dell, Cisco, EMC, IBM, HDS

Lower TCO

Commodity Hardware, Pre-Tuned to Workload Specific Best Practices

High Scale

Reference Architectures deliver proven scale up to 100TB of User Data

Reduced Risk

Validated by Microsoft; better choice of hardware; application of Best Practice 4

FAST TRACK CUSTOMER SUCCESS: CASE STUDIES

5

FAST TRACK FOR SQL SERVER 2012 PERFORMANCE

SQL Server 2012 Upgrade Scenario • Fast Track for SQL Server 2008 R2 Reference Architecture: HP DL380 • • 20TB Capacity, 2.4 GB/s Rated Throughput Upgrade to SQL Server 2012 Benchmark Results:

No Change in Rated Throughput

FAST TRACK FOR SQL SERVER 2012 PERFORMANCE

SQL Server 2012 ColumnStore Index Scenario • Apply ColumnStore Index to benchmark schema • • No query changes No Hardware changes Benchmark Results:

2x

Fast Track Rated Throughput (5 GB/s)

FAST TRACK FOR SQL 2012 SUMMARY

• • Fast Track for SQL Server 2012 delivers balanced database and hardware configurations for latest SQL Server and hardware partner capabilities.

Customers get new and enhanced benefits from Fast Track for SQL Server 2012 8

CALL TO ACTION

• • • • • Contact your preferred Fast Track Hardware Partner for SQL Server 2012 Fast Track Data Warehouse Solutions Look for the latest information at; SQL Server Data Warehousing Consider upgrading to SQL Server 2012 for your Analytical workload Add SQL Server 2012 ColumnStore Indexing and unlock single query performance by 5,10, even 20x!

Potential 2x or more workload performance gains with no hardware changes for Fast Track 2008 R2 based systems upgraded to SQL Server 2012 with ColumnStore Index!

FURTHER. FORWARD. FASTER.

•

Learn more

Visit the Microsoft Virtual Academy Free technical SQL Server training courses •

Get more

Download SQL Server 2012 Trial Software 180-day evaluation of SQL Server 2012 •

Do more

Participate in virtual launch activities and collect points for prizes The more points you earn, the bigger your prize could be

© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.

The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

CASE STUDY LINKS

• • Safety-Kleen Case Study Ontario Lottery & Gaming (OLG) Case Study • • • • • LC Waikiki Las Vegas Sands AFLAC Case Study Tellmore Case Study Case Study Steinmart Case Study Case Study