Transcript Our Sponsors

Understanding Azure SQL DB Service Tiers
Warner Chaves
SQL MCM / MVP
SQLTurbo.com
Pythian.com
Our Sponsors
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.
 Point-in-time Restore: 14 days.
 DR: Geo-Restore, Standard Georeplication.
 Auditing allowed.
 Performance: 10-20-50-100 DTU.
S0
10 DTU
S1
20 DTU
S2
50 DTU
S3
100
DTU
Premium
 Size Limit: 500GB.
 Point-in-time Restore: 35 days.
 DR: Geo-Restore, Standard or
Active Geo-replication.
 Parallelism.
 Columnstores.
 Auditing allowed.
 Performance: 125-250-1000 DTU.
P1
100 DTU
P2
200 DTU
P3
1000 DTU
Standard vs Active Geo-Replication
 Standard
 RTO < 2h (30 secs on V12)
 RPO < 30m (5 secs on V12)
 Active
 RTO < 2h (30 secs on V12)
 RPO < 5m (5 secs on V12)
 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
S3
100
200
2400
5100 trx/min
P1
125
200
2400
105 trx/sec
P2
250
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.
TDE on all editions.
 TRUNCATE PARTITION.
 Upcoming: SQL Query Store.
Demo: Dynamic Data Masking
Future ahead
 Elastic database pools
 Azure SQL Datawarehouse
 Check videos of the sessions from Ignite 2015 on
channel9.microsoft.com
QA?