Transcript Microsoft Azure SQL Database Overview

An enterprise-grade database-as-a-service
platform with easily accessible
tier-1 capabilities
Hybrid Cloud
Shared
Lower Cost
On Premises
SQL
SQL
SQL
Dedicated
Higher Cost
SQL
Higher Administration
SQL
SQL
SQL
SQL
SQL
SQL
Off Premises
Lower Administration
Enterprise-grade database platform
with cloud economics
•
•
••
••
•••
•••
Incremental performance and features
with easy upgrade and downgrade
*The 99.99% availability SLA does not apply to Web and Business editions, which continue to be supported at 99.9% availability.
Business Continuity
and Data Protection
Self-managed and
Familiar
Self-service restore
Disaster recovery
Compliance-enabled
Self-managed
Programmatic APIs
Familiar tools and language
Web / Business
Basic / Standard / Premium
Machine
Machine
Compute
DB 2
DB 2
DB 4
DB 7
DB 7
DB 55
DB
DB 8
DB 8
Memory
DB 6 DB
6
DB 9
DB 9
DB 1
Bounding boxes
eliminates noisy
neighbors
DB 4
DB 7
DB 2
DB 5
DB 8
Memory
DB 3
DB 6
DB 9
Reads
DB
4
DB 3
Noisy
neighbor!
Reads
Writes
DB 1
DB 3
Writes
DB 1
Compute
Basic Standard
Premium
P3
B S0
S1
S2
P1
P2
Performance is easily scaled up or down to
meet changing workload and business needs
Use monitoring and alerts to understand
and manage resource utilization
Vertical: scale-up or scale-down
Scale up/down
Horizontal: scale-out or scale-in
Premium
P2
Premium
P1
Standard
Basic
SO
[0-100]
[400-500]
Standard
Basic
[100-200]
S1
Basic
[200-300]
[200-300]
Basic
[300-400]
Scale out/in
Basic
[400-500]
Standard
S2
[500-600]
Basic
[500-600]
Basic
[600-700]
PREVIEW
SQL Database Shards
Simplified development & management of high-throughput
applications scaled out across a large number of databases
Elastic Scale and
Performance
Self-managed and
Familiar
Predictable performance levels
Scale up/down & out/in
Dashboard views of DB metrics
Self-managed
Programmatic APIs
Familiar tools and language
Basic, Standard & Premium databases are protected
from accidental data corruption, deletion & disaster
DB1
DB1
DB1
DB1
DB1
Geo-replication minimizes business
interruption from possible disasters
Compliant and secure when
configured and used responsibly
PREVIEW
Audit
log
Azure Storage
Auditing
SQL Database
Auditing enhances compliance & security
and provides operational insights
Elastic Scale and
Performance
Business Continuity
and Data Protection
Predictable performance levels
Scale up/down & out/in
Dashboard views of DB metrics
Self-service restore
Disaster recovery
Compliance-enabled
Built-in maintenance and fault tolerance,
with self-service management
Supports tools and platforms
that you use already
Enterprise-grade database-as-a-service
with easily accessible tier-1 capabilities
microsoft.com/sqlserver and Amazon Kindle Store
microsoftvirtualacademy.com
Azure Machine Learning, DocumentDB, and Stream Analytics
http://channel9.msdn.com/Events/TechEd
www.microsoft.com/learning
http://microsoft.com/technet
http://developer.microsoft.com