Transcript Azure DB Service Tiers

GETTING STARTED
WITH AZURE SQL DB
Warner Chaves
SQL MCM / MVP
SQLTurbo.com
Pythian.com
Bio
•
SQL Server DBA for 10 years.
•
Previously an L3 DBA at HP, now a Principal Consultant at Pythian
in Ottawa Ontario.
•
SQL Server MCM and MVP.
•
Twitter: @warchav
•
Email: [email protected]
•
Blog: sqlturbo.com
•
Company site: pythian.com
Agenda
• GOAL: provide an introduction and overview of the Azure
SQL Database service.
• We’ll cover:
 How to sign up.
 Navigating the portal.
 The different service levels.
 New features coming cloud first.
Signing up!
• Go here:
• http://azure.microsoft.com/en-us/pricing/free-trial/
• You’ll need to put in your info but you won’t get charged
until after the trial month if you don’t cancel.
What is it?
• The SQL database as a service offering on Azure (OLTP).
• Fully managed by MS as part of Azure.
• It’s not a full instance. Many features that you’re used to
don’t exist because it’s fully managed.
• Used to be 2 size based tiers, now it’s 3 Service Level
based tiers.
Before and After
• Before: Web and Business. Based purely on size.
• Now: 3 service tiers and sub tiers.
BASIC
S0
S1
S2
P1
P2
P3
S3
Basic
• Size Limit: 2GB.
• Point-in-time Restore: 7 days.
• DR: Geo-Restore to another Azure region.
• Auditing allowed.
• Performance: 5 DTU.
Standard
• Size Limit: 250GB.
S0
10 DTU
S1
20 DTU
S2
50 DTU
S3
100
DTU
• Point-in-time Restore: 14 days.
• DR: Geo-Restore, Standard
Geo-replication.
• Auditing allowed.
• Performance: 10-20-50-100
DTU.
Premium
• Size Limit: 500GB.
• Point-in-time Restore: 35 days.
P1
100 DTU
P2
200 DTU
P3
1000 DTU
• DR: Geo-Restore, Standard or
•
•
•
•
Active Geo-replication.
Partitioning.
Columnstores.
Auditing allowed.
Performance: 100-200-1000 DTU.
Standard vs Active Geo-Replication
• Standard
• RTO < 2h
• RPO < 30m
• Active
• RTO < 1h
• RPO < 5m
• Active provides failover control.
• Active provides up to 4 read-only replicas.
Official Pricing List
• For the official published price please check:
• http://azure.microsoft.com/en-us/pricing/details/sql-
database/
• The price can change depending on your specific
agreements with Microsoft.
Demo: Walkthrough Azure Portal and
SSMS experience
Demo: Point-in-Time Restore
DTU?
• Database throughput unit.
• A comparison unit of integrated database performance.
• Blend of CPU + Data IO + Log IO + Memory.
• Based on an internal OLTP benchmark from the Azure
team.
Tier DTUs
Tier
DTU
Max Threads
Max
Sessions
Benchmark
Throughput
Basic
5
30
300
16600
trx/hour
S0
10
60
600
521 trx/min
S1
20
90
900
934 trx/min
S2
50
120
1200
2570 trx/min
P1
100
200
2400
105 trx/sec
P2
200
400
4800
228 trx/sec
P3
1000
1600
19200
735 trx/sec
Demo: Basic vs S1 comparison
Cloud-first
• MS is now deploying features on Azure SQL that are NOT
in the “box” version of SQL Server:
 Dynamic Data Masking.
 Row-Level Security.
 ALTER COLUMN ONLINE.
 TRUNCATE PARTITION.
 Upcoming: SQL Query Store.
Demo: Dynamic Data Masking
QA?