FAST TRACK DATA WAREHOUSE FOR SQL SERVER 2012

FAST TRACK DATA WAREHOUSE FOR SQL SERVER 2012 Eric Kraemer Senior Program Manager This document has been prepared for limited distribution within Microsoft. This document contains materials and information that Microsoft considers confidential, proprietary, and significant for the protection of its business. The distribution of this document is limited to those solely involved with the program described within. Confidential and Proprietary © 2011 Microsoft Last Updated:

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 Workload specific Software & System designs that help Customers accelerate their SQL Server 2012 projects. Software: • SQL Server 2008 R 2 Enterprise • SQL Server 2012 • Windows Server 2008 R 2 Database Configuration: • Workload Specific • Database Architecture • SQL Server settings • Windows Server settings • Performance Guidance 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 100 TB 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 R 2 Reference Architecture 20 TB Capacity, 2. 4 GB/s Rated Throughput Upgrade to SQL Server 2012 : HP DL 380 Benchmark Results: No Change in Rated Throughput

FAST TRACK FOR SQL SERVER 2012 PERFORMANCE SQL Server 2012 Column. Store Index Scenario • Apply Column. Store Index to benchmark schema • No query changes • No Hardware changes Benchmark Results: 2 x Fast Track Rated Throughput GB/s) (5

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 Choice Configurations from Major hardware partners Latest generation servers & storage Top industry hardware & software engineering Preview Fast Track 4. 0 performance in an MTC near you (Q 2 CY 12) Performance Customer Value Balanced capacity and performance for SQL Server 2012 Optimized for Column. Store Index (CSI) 2 x FT Rated throughput increase over SQL 2008 R 2 benchmarks using SQL 2012 CSI Now supports Solid State storage 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 Column. Store Indexing and unlock single query performance by 5, 10, even 20 x! Potential 2 x or more workload performance gains with no hardware changes for Fast Track 2008 R 2 based systems upgraded to SQL Server 2012 with Column. Store 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 collect points for prizes The more points you earn, the bigger your prize could and be

© 2011 Microsoft Corporation. All rights reserved. Microsoft, 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 IFSTTAR - Case Study LC Waikiki - Case Study Las Vegas Sands - Case Study AFLAC - Case Study Tellmore - Case Study Steinmart - Case Study