Windows Azure Migrating SQL Server WorkloadsSpeakerTitleOrganization

Agenda

Recap

Migrating SQL Server Workloads

SQL Server IaaS Best Practices

Summary

Recap

Check Out These Presentations FirstWindows Azure Infrastructure as a ServiceOverview of Windows Azure Virtual Machine, Storage and Networking

Windows Azure - Migrating Apps and WorkloadsOverview of what kinds of apps and workloads to migrate and how to get started

PaaS SaaSPhysical Virtual IaaS

A Continuous Offering From Private to

Public Cloud

Windows Azure SQL Database

IaaS Workloads – all about the appLine of Business ApplicationsCustom Applications, CRM, CMS, ERP, Business Intelligence

Application InfrastructureFile Servers, Databases, Identity, Source Control

Developer, Test and Staging Environments Quickly Provision and Un-provision Entire Environments

Hybrid ApplicationsApplications that span your data center and the cloud

Migrating SQL Server Workloads

SQL Server and Windows Azure VMSupported VersionsSQL Server 2012, 2008 R2, 2008

Supported FeaturesAll SQL Server features supported except failover clustering *

SQL Server ProvisioningCloud-first using stock images, bring your own server / VHD, capture cloud images

SQL Server LicensingPay by the hour or migrate your own license via Software Assurance ** * AlwaysOn Availability Groups not supported until GA

** Windows Azure Compute and Storage charges also apply

Virtual Machine Sizes and SQL Editions

Each Persistent Data Disk Can be up to 1 TB

VM Size CPU Cores Memory Bandwidth# Data Disks SQL Edition

Extra Small Shared 768 MB 5 (Mbps) 1 Express

Small 1 1.75 GB 100 (Mbps) 2 Standard

Medium 2 3.5 GB 200 (Mbps) 4 Standard

Large 4 7 GB 400 (Mbps) 8Standard / Enterprise

Extra Large 8 14 GB 800 (Mbps) 16Standard / Enterprise

Demo

Provisioning SQL Server with a Stock Image

SQL Server on Virtual MachinesBest Practices

Running SQL Server in a Windows Azure VMStorage RecommendationsDo not use write cachingAvoid using OS drive for large databasesConsider putting database and transaction log files on separate drivesConsider putting tempdb on the non-persistent cache disk (D:\)

Database RecommendationsConsider using database page compression to reduce I/O

High Availability RecommendationsConsider latency between primary and replica when choosing sync mode

Demo

Using Windows Azure for SQL Server Disaster Recovery

SQL Server or Windows Azure SQL Db? SQL Server

(IaaS)Windows Azure SQL

Database (PaaS)

Development

Migrate Existing Apps Develop New Apps

Management

Full Control Managed Service

Compatibility

Full SQL Server Capabilities Based on SQL Server Technology

Shared TechnologyNetwork transport (Tabular Data Stream)

SQL dialect (Transact-SQL)Data access APIs (ADO.NET, ODBC, JDBC)

Development tools (SQL Server Data Tools)Management tools (SQL Server Management

Studio)

Summary

Microsoft has a continuous offering from private to public cloudWindows Azure now supports IaaS workloadsSQL Server is fully supported on Windows Azure Virtual MachineIaaS is about migration, PaaS is about new development

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