app services data services compute Global Physical Infrastructure
app services data services compute Global Physical Infrastructure servers / network / datacenters Automated Elastic Managed Resources Usage Based W. US, East US, N Central US, S Central US, N Europe, W Europe, E Asia, SE Asia + 24 Edge CDN Locations networks
NON-RELATIONAL 01001101001 01010100101 00011101010 0100101 A cloud storage service offering the simplest way to store large amounts of unstructured text or binary data, such as video, audio and images, and for creating virtual hard drives in the cloud. A No. SQL key/value store that provides simple access to semi-structured data at a lower cost for applications that do not need robust querying capabilities A Big Data implementation 100% compatible with Hadoop. Best for inexpensive, scalable storage of data Best for inexpensive, scalable storage of semistructured data Best for Big Data Analytics across semi-structured and unstructured data A full-featured instance of SQL Server running in a Windows Azure Virtual Machine for quickly and easily running or testing SQL Server applications in the cloud Best for existing and new applications needing full SQL Server feature set A feature-rich, fully managed relational database service that offers a highly productive experience with businessready capabilities built on SQL Server technology Best for new cloud applications needing relational capabilities and high availability
INFRASTRUCTURE AS A SERVICE (Iaa. S) SQL Server in a Windows Azure Virtual Machine PLATFORM AS A SERVICE (Paa. S) DB Windows Azure SQL Database Full Control & Flexibility Simplified Administration Highly Customized Environment Fully Managed Service Eliminate Hardware Costs Eliminate Hardware & Administrative Costs Decrease Time to Market Build Modern Apps 5
Microsoft Data Platform Deployment Solutions Public Cloud Windows Azure SQL Database service (Formerly SQL Azure Database) KEY SCENARIOS SQL Server in a Windows Azure Virtual Machine Use both SQL Server in Windows Azure VM and Windows Azure SQL Database in a single app.
VM Size CPU Core Memory Max Attached v. Disks A 0 Shared 768 MB 1 A 1 1 1. 75 GB 2 A 2 2 3. 50 GB 4 A 3 4 7. 00 GB 8 A 6 4 28. 00 GB 8 A 4 8 14. 00 GB 16 A 7 8 56. 00 GB 16 (<=1 TB each) 7
Setup SQL Server Always. On Availability Groups in Azure VMs Setup On-premise Primary DB, with failover replicas in Azure AZURE DATA CENTER Always. On Primary SQL Server 2012 Always. On Synchronous Secondary SQL Server 2012 IN-HOUSE DATA CENTER Always. On Primary SQL Server 2012 AZURE DATA CENTER Always. On Async Secondary Always. On Synchronous Secondary SQL Server 2012
Windows Azure Virtual Network Build virtual networks that scale Traditional, familiar approach to build extension to datacenter Complete control over network configuration Define your own IP addresses Enables complex hybrid scenarios And compliance scenarios for sensitive data Apps on Azure VMs can securely Access on-premise Databases Including Domain-Attach Azure VMs to on-premise AD Corpnet
Low TCO for Existing Apps Full SQL Server Capability Flexibility & Control Managed Infrastructure No App Changes Required High Availability of Database with Always. On Availability Groups Full Control of Virtual Machine Fully Managed Infrastructure Common Identity (Active Directory Integration) 99. 95% SLA for Virtual Machine Familiar Development tools Library of VM Templates Advanced Security (Transparent data encryption & auditing) Full Business Intelligence Functionality Single Pane of Glass to Manage with System Center 2012 13
Simplified Across with proven Deployment ENVIRONMENTS Performance 14
Replica 2 Replica 1 Multiple Physical Replicas • Automatic HA built-in • One primary node • Two online replicas • Writes are synchronously replicated to online Replica 3 Single Logical Database secondaries • No database downtime even as Azure systems patched, upgraded • 99. 9% database uptime SLA
Massive Scale Engage 1000 s of nodes within the cluster Simplified Development and Administration 10 GB DB 10 GB DB Robust programming & connectivity model for creating dynamic applications Simplified Multi-tenant Database Tiers Multi-tenancy provides great efficiencies by increasing density of tenants per database Applications don’t have to make a static decision about tenant placement 100 GB Database Single DB Bottlneck 10 GB DB 10 GB DB Many DBs w/ Concurrent Read and Writes 16
Managed Platform & Infrastructure Fully managed (no patching of DB or OS) Built in HA for Database 99. 9% SLA Simplified Azure Management Portal Dynamic Scalability Fast & Flexible Platform Based on SQL Server Technology Scale Out Rapid Application Development Common Architecture with SQL Server Easy Database Portability Insights with SQL Reporting Scale via Azure Management Portal Familiar Development Tools Choice of Platform 18
Start Migrate Existing or Are any of the following requirements true? Common code base between on and off-premises Feature dependency on SQL Server that is not available yet on SQL DB Stronger Isolation needs than what is available in SQL DB (e. g. , domain join) Existing Developing new application /service New No Can you (re)architect or partition your app/service to be scale-out aware (database sharding)? No Yes Yes Database size > 150 GB No Windows Azure SQL Database SQL Server in a Windows Azure VM 19
TYPICAL CLOUD DEPLOYMENT FOR A MODERN APPLICATION RELATIONAL 01001101000111010100 100101 SQL DATABASE HDINSIGHT TABLES BLOBS SERVICE BUS
Xamarin http: //msdn. Microsoft. com/stocktrader 22
Windows Azure mva
http: //channel 9. msdn. com/Events/Tech. Ed www. microsoft. com/learning http: //microsoft. com/technet http: //microsoft. com/msdn
- Slides: 26