Shared Lower cost Hybrid Cloud WA SQL Database Virtualized Databases Dedicated Higher cost SQL Server in WA VM Virtualized Machines SQL Server Private Cloud Virtualized Machines+ Appliances SQL Server Physical Machines (raw.

Download Report

Transcript Shared Lower cost Hybrid Cloud WA SQL Database Virtualized Databases Dedicated Higher cost SQL Server in WA VM Virtualized Machines SQL Server Private Cloud Virtualized Machines+ Appliances SQL Server Physical Machines (raw. 

Shared
Lower cost
Hybrid Cloud
WA SQL Database
Virtualized Databases
Dedicated
Higher cost
SQL Server in WA VM
Virtualized Machines
SQL Server Private Cloud
Virtualized Machines+ Appliances
SQL Server
Physical Machines (raw iron)
High Control
Low Control
Cloud Backup
AlwaysOn Replica
in Azure
SQL Server with
Azure Storage
integration
SQL Server with
Azure IaaS
Deploy DB to
Azure VM
CREATE CREDENTIAL mystoragecred
WITH IDENTITY = ‘mystorage',
SECRET = ‘<your storage access key>
BACKUP DATABASE mydb TO URL ='https://mystorage.blob.core.windows.net/backup-container/mydb20130411.bak'
WITH CREDENTIAL = ‘mystoragecred',
FORMAT, COMPRESSION, STATS = 5,
MEDIANAME = ‘mydb backup 20130411', MEDIADESCRIPTION = 'Backup of mydb'
CTP1
SQL 2008 R2 SQL 2012, SQL 2014
Upload VHD
sysprep
Multiple SKUs Pay by Minute
monthly (roughly)
patch
License Mobility
create
patch
Sysprep support for
Analysis Services
Integration Services
Management Tools (SSMS)
Other Shared Features
Performance Improvements
Create a slipstream package
with CU2
Run SQL Server Setup
Invoke Image Preparation
Select Features
Generalize image
Upload to Windows Azure
Solution
New SSMS Wizard: Deploy Database to a Windows Azure VM
Portal
Report
Deployed
Not deployed
Detailed log
Virtual Machine
Windows
Server
Blob
Microsoft Confidential
Memory
Maximum
Disk Space Allocated
data disks
for Virtual Bandwidth
(1 TB
Machines (Mbps)
each)
Maximum
IOPS (500
maximum
per disk)
ExtraSmall Shared
768 MB
20 GB
5
1
1x500
Small
1
1.75 GB
70 GB
100
2
2x500
Medium
2
3.5 GB
135 GB
200
4
4x500
Large
4
7 GB
285 GB
400
8
8x500
ExtraLarge 8
14 GB
605 GB
800
16
16x500
A6
4
28 GB
285 GB
1,000
8
8x500
A7
8
56 GB
605 GB
2,000
16
16x500
Virtual
Machine
Size
CPU Cores
http://msdn.microsoft.com/en-us/library/windowsazure/dn197896.aspx
WhitePaper http://go.microsoft.com/fwlink/?LinkId=306266
Windows
Azure
mva
http://channel9.msdn.com/Events/TechEd
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn