See the Largest Mission Critical Deployment of Microsoft SQL Server around the World

1. SESSION CODE: DAT305 See the Largest Mission Critical Deployment of Microsoft SQL Server around the World What are the largest SQL projects in the world? Kevin Cox – kevincox@microsoft.com SQL CAT Microsoft Corporation Srik Raghavan – srikr@microsoft.com SQL Server Engine PM Microsoft Corporation

2. Session Objectives and Takeaways • Learn about the largest SQL Server projects • SQL will scale to handle any size project • SQL is enterprise ready

3. SQL CAT (Customer Advisory Team) • Achieving Customer Success • MySpace - 4.4 million concurrent users at peak time, 8 billion friend relationships, 34 billion e-mails, 1 PetaByte store, scale-out using SSB and SOA http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?casestudyid=4000004532 • bwin- Most popular European online gaming site – 30k db transactions/second, motto: “Failure is not an option”; 100 TB total storage http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?casestudyid=4000004138http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?casestudyid=4000001470 • Korea Telecom - Largest telco in Korea serves 26 million customers; 3 TB DWhttp://www.microsoft.com/casestudies/Case_Study_Detail.aspx?casestudyid=4000001993 • Making a Better Product • Drives feedback and product requirements back into SQL Server development teams from deep and strategic customer and ISV engagements • Sharing with the Community • http://sqlcat.com • http://blogs.msdn.com/mssqlisv The SQL Server Customer Advisory Team (SQL CAT) represents the customer-facing resources from the SQL Server Product Group. SQL CAT is comprised of product and solution experts that regularly engage in the largest, most complex, and most unique customer deployments worldwide.

4. Design Wins Program The Customer Experience (CX) Design Wins Program is how the Microsoft Business Platform Division identifies and invests in strategic and large-scale customer projects with challenging, unique, and complex applications running on the Microsoft platform. • Customer Benefits • Direct engagement from product group (SQL CAT technical/project experience) • Reduced risk • Architecture Best Practices and Guidance • SQL CAT-led service offerings (i.e. Architecture Design Reviews) optional • Lab visit to Redmond or Regional Microsoft Technology Center (MTC) optional • Business Investment Funds (BIF) optional/limited availability • Invitations to special events/programs (i.e. TAP) optional • Co-marketing and PR • Example (SQL Server Qualifying Criteria) • 10+ TB DW, 3k tx/s OLTP, Large 500GB+ Cubes, Competitive migrations, Complex deployments, Server Consolidation (1000+) • Nominating a Customer • Complete a nomination form: http://sqlserver/customers/customeradvisoryteam/default.aspx • Submit completed form to the Design Win Program alias “dsignwin”

5. Top statistics

6. Largest SQL Server Projects DATA WAREHOUSE

7. Pan Starrs Project • Largest Astronomy project in history • 4 telescopes capturing 1.5 giga pixel images • 100TB Per instance in 5 databases • 12 servers for total data > 1.2PB • 5+TB added per day • HA/DR • Relying on backups of the input files for now.

8. Telecom • CDR Analytics • 70TB Relational • 4TB largest cube • 100+ concurrent queries • Itanium 64 core with storage system rated over 20GB/sec throughput • Loading 1TB in < 30 minutes • Processing 1m rec/sec in AS cubes

9. Hilton Hotels • Room forecasting system • Full suite of SQL products (SQL, AS, IS, RS) • Scale out AS and RS • Load Balanced Analysis Services reader machines • 40 to 50 concurrent users per RS server • Complex queries • Large data sets returned to many clients • IBM xSeries and IBM Blade Center servers • Case study: http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=49192

10. Hilton Architecture

11. Stein Mart • First Fast Track case study • Saved $50,000 / month after AS/400 migration • Faster results – 3 hours of processing instead of 14 hours • Less people to maintain • Users love the new tools! • 4 TB data warehouse • http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?casestudyid=4000007013

12. Largest SQL Server Projects OLTP

13. MySpace • 500+ SQL Servers, adding new ones every week • Total data managed > 2.5 PB • Data Dependent Routing, Distributed Partitioned Views, Replication, SODA • Currently moving to Windows 2008 / SQL 2008 • Great article on architecture changes as they grew: http://www.baselinemag.com/article2/0,1540,2082921,00.asp

14. MySpace (cont) • High Availability • Widows Clusters 7+1, moving to 10+1 • Unattended patching via custom Powershell scripts and management control screen • Extensive testing before patching • Continually improving operations process • 3,000 – 7,000 connections average • 2 data centers • Doing SAN snapshots between sites • In case of loss of one site, can bring up other site to take over within a few hours.

15. Business • Online gaming applications - Europe‘s largest betting line-up Sports Poker Casino Skill Games • 90 different sports covered in 22 languages • > 12,000 different bets offered per day • > 3 million individual and combination bets placed every day • Bwin.com sponsors top world soccer teams Real Madrid AC Milan FC Bayern Munich • Key Technologies • Running on SQL Server 2008 & Windows 2008 Enterprise • Windows Communication Foundation • Synchronous database mirroring between two centers 12 km apart • Added 1 ms delay on transaction • 99.99x% availability @ 24 x 7 since migrating to SQL from Oracle. • 100.00% uptime in 2008 and 2009 (since moving to SQL 2008 and Windows 2008) • Zero data loss (financial transactions are involved) • Replication and Log shipping for most databases • DB Mirroring for betting data base. • Full suite of SQL products - IS, AS and RS • ASP.NET for application

16. Some numbers • Peak financial transactions 6000 per second • Peak db transactions 30,000 per second • Databases 800+ • Instances 100+ • Largest table 2 billion rows • Total data in SQL Server 100+ TB • Backup of 2 TB over network under 1 hr • Largest machines 64 core 512 GB IA2 HP 6 x 32 core IA2 • 400% boost in performance on 128 cores 256GB RAM on IA64 using SQL 2008 R2 • http://sqlcat.com/whitepapers/archive/2009/08/13/a-technical-case-study-fast-and-reliable-backup-and-restore-of-a-vldb-over-the-network.aspx • http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?casestudyid=4000001470

17. Retail Application • 1,200 stores • SQL Standard • 10 GB average • 15,000 cash registers • SQL Express • 10 MB database average • 1 Corporate Server • SQL Enterprise • Windows Cluster + DB Mirroring • AS, IS, RS • 12+ TB database, 1.5 TB cube.

18. Retail Application (cont) • Merge replication for products & pricing • Service Broker for all transactions • One of the largest Service Broker and replication projects in the world • 2 Million SKUs (products) • 25 Million Accounts • 10 million transactions / day • SQL Server, AS, IS, RS • Windows Cluster, DB Mirroring, Log Shipping

19. High Availability

20. Data Tier Architecture

21. Data Tier Architecture

22. Data Tier Architecture

23. Data Tier Architecture

24. Data Tier Architecture

25. Scaling SQL Server • How do you: • Manage an 80 TB database • Back up a petabyte • Build an index on a trillion row table

26. How do they scale? • How do you: • Manage an 80 TB database • Back up a petabyte • Build an index on a trillion row table • Answer • Break it into manageable size pieces

27. Scalability Feature: Table Partitioning

28. Scalability Feature: Table Partitioning

29. Scalability Feature: Local Partitioned View

30. Scalability Feature: Cross Database Partitioned View

31. Scalability Feature: Distributed Partitioned View

32. Scalability Concept: Data Dependent Routing

33. Summary • SQL Server will scale to handle any size you need • Database size • Transactions per second • Concurrent users • SQL Server is enterprise ready

34. Required Slide Track PMs will supply the content for this slide, which will be inserted during the final scrub. DAT Track Scratch 2 Win • Find the DAT Track Surface Table in the Yellow Section of the TLC • Try your luck to win a Zune HD • Simply scratch the game pieces on the DAT Track Surface Table and Match 3 Zune HDs to win

35. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

36. Required Slide Complete an evaluation on CommNet and enter to win!

37. Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st http://northamerica.msteched.com/registration You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year

38. QUESTIONS?

39. © 2010 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.

40. Required Slide