Data Series: SQL Server in Windows Azure Virtual Machine vs. SQL Database

source from msdn

Criteria

SQL Server inside Windows Azure VM

Windows Azure SQL Database

Time to Solution    
Migrate Existing Apps

Fast

Moderate

Build New Apps

Moderate

Fast

Cost of Solution

Hardware Administration

None

None

Software Administration (Database & OS)

Manual

None

Machine High Availability

Automated (99.9% Uptime SLA at commercial release)

N/A

Database High Availability

With extra VMs and manual setup via AlwaysOn (at commercial release), DBM; DR via log shipping, transactional replication

Standard Feature (99.9% DB uptime SLA)

Cost

Medium

Low

Scale Model

Scale-Up

X-Large VM
(8 cores, 14GB RAM, up to 16 TB disk space)

Not Supported

Scale-Out

Manual via AlwaysOn read-only secondaries, scalable shared databases, peer-to-peer replication, Distributed Partitioned Views, and data-dependent routing (manual to setup, and applications must be designed for these features)

SQL Database Federation (automated at data tier, with applications designed for Federation)

Control & Customize

OS and VM

Full Control

No Control

SQL Server Database Compatibility, Customization

Full support for SQL Server 2012 box product features including database engine, SSIS, SSAS, SSRS

Large subset of SQL Server 2012 features

Hybrid

Domain Join and Windows Authentication

Yes

Not possible

Data Synchronization via Azure Data Sync

Supported

Supported

Manageability

Resource Governance & Security Level

SQL Instance/VM

Logical DB Server

Tools Support

Existing SQL Server tools such as SSMS, System Center, and SSDT

Existing SQL Server tools such as SSMS, System Center, and SSDT

Manage at Scale Capabilities

Fair

Good

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s