[email protected] [email protected] Shared Lower cost Managed database service Focus on business logic WA SQL Database - PaaS 100% Compatibility Rapid self-service provisioning SQL Server in WA VM -

Download Report

Transcript [email protected] [email protected] Shared Lower cost Managed database service Focus on business logic WA SQL Database - PaaS 100% Compatibility Rapid self-service provisioning SQL Server in WA VM - 

[email protected]
[email protected]
Shared
Lower cost
Managed database service
Focus on business logic
WA SQL Database - PaaS
100% Compatibility
Rapid self-service provisioning
SQL Server in WA VM - IaaS
Elastic/Self-Service capabilities
Full h/w control
Dedicated
Higher cost
SQL Server Private Cloud - IaaS
Full h/w control
Roll-your-own HA/DR/scale
SQL Server
High Control
Low Control
management portal
•
•
•
•
image library
Persistent, durable VM disks
99.9% SLA
Networking Improvements
Linux support
storage
virtual machine
• Performance Improvements
• SQL, SharePoint, AD support
• Gallery images, Windows, SQL, Linux
• Cloud First VM Creation Experience
Support: http://support.microsoft.com/kb/956893
Virtual Machine hosted on Windows Azure
Client Computer
Windows
Remote
Desktop
SQL Server
Management
Studio
Default TCP port
1433
Windows
Azure
Endpoint
Different from
3889
Windows
Azure
Endpoint
Virtual
Machine
Firewall
TCP port
3389 opened
during
provisioning
Virtual
Machine
Firewall
Virtual Machine
Desktop
Connection to SQL Server
using Windows
Authentication
SQL
Server
Endpoint
SQL Server
Database
Engine
Connect to SQL Server
using SQL Server
Authentication.
Your VHD uploaded to Windows Azure
Client Computer
Windows
Remote
Desktop
Windows Azure
Endpoint
Different from 3889
Virtual
Machine
Firewall
Virtual
Machine
Desktop.


Prepare Subscription:
PS C:\> Import-AzureSubscription -PublishSettingsFile <PathToFile>
PS C:\> Set-AzureSubscription -CurrentStorageAccount <AccountName>
Prepare batch:
PS C:\> $pwd = ‘my_password'
PS C:\> $vm1 = New-AzureVMConfig -Name ‘MyVM1' -InstanceSize ‘Medium' -ImageName
‘SQL_Server_Image_Name' | Add-AzureProvisioningConfig -Windows -Password $pwd
Provision:
PS C:\> New-AzureVM -ServiceName ‘my_service' -VMs $vm1 [, $vm2, $vm3 …]
Provide access:
PS C:\> Get-AzureVM -ServiceName "my-service" -Name ‘MyVM1’ | Add-AzureInputEndpoint
-Name “SQL" -PublicPort 14331 -LocalPort 1433 | Update-AzureVM
https://www.windowsazure.com/en-us/develop/downloads/
Virtual machine
My Content
Integration services
Analysis services
Recommendation
ASP.NET Web API
Technical
Content
Depository
Microsoft Corporate Network
(Redmond)
MSIT AZITBITAP SharePoint VNet
(Windows Azure Preview – Dublin)
SQL 2012
SharePoint
Server
Web FrontEnds
VNGateway
SharePoint
Middle-Tier
MSIT Setup & Deployment
Determine # and size of
VMs
Configure Windows
Azure Virtual Network
Provision VM’s,
Configure Corpnet
access
Upload VHD with install
bits
Install SharePoint Farm
and SQL BI
memory
Set-AzureVMSize
Use SQLIO
Storage Analytics
max server
Set-AzureOSDisk)
Consider putting tempdb on
non-persistent cache disk
(D:\)
Consider using database
page compression to
reduce I/O
http://www.windowsazure.com/
http://social.msdn.microsoft.com/Forums/en/WAVirtualMachinesforSQLServer/
Windows Azure how to guides
Getting started with SQL Server on a Windows Azure virtual machine
Provisioning a SQL Server virtual machine on Windows Azure
SQL in WA VM Early Adoption Cook Book
https://www.windowsazure.com/en-us/pricing/details/
http://www.windowsazure.com/en-us/pricing/calculator/?scenario=virtualmachines
mva
http://northamerica.msteched.com
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn
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 Technology
Network 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)
Quick, low-risk way to evaluate
Hyper-V
Converts VMDK->VHD and config
settings
Replaces VMware tools with HyperV Integration Services
Easy-to-use wizard-driven GUI
Supports ESx 4.1 & 5, vCenter
Supports data-center automation
workflows
https://connect.microsoft.com/site14