sql databases on azure - files.meetup.comfiles.meetup.com/13745382/session 1 - sql azure.pdf ·...
TRANSCRIPT
This is madness?
THIS IS SQL!
Options for SQL databases on Azure
SQL
Dedicated
Higher Cost
Shared
Lower Cost
Higher Administration Lower Administration
Hybrid Cloud
On Premises
Off Premises
SQL SQL
SQL SQL SQL
SQL SQL SQL
SQL
–Microsoft
–Microsoft
–Microsoft
–Microsoft (SLA 99.99%)
+ Upgrading databases
+ Threat detection and auditing
SQL Database on Azure
Azure SQL DatabaseA managed cloud database for app developers
https://azure.microsoft.com/en-us/services/sql-database/
Performance and
Scalability
• Predictable performance
• Scale up & down
• Automatic tuning
Business continuity
and data protection
• Self-service restore
• Disaster recovery
• Compliance enabled
Self managed and
familiar
• Minimal management
• APIs
• Familiar tools
Max DTUs 5
Max Database Size (GB) 2
Max in-memory OLTP storage (GB) N/A
Max concurrent workers 30
Max concurrent logins 30
Max concurrent sessions 300
Point-in-time-restore Any point last 7 days
Disaster recovery Active Geo-Replication
S0 S1 S2 S3
Max DTUs 10 20 50 100
Max Database Size (GB) 250
Max in-memory OLTP storage (GB) N/A
Max concurrent workers 60 90 120 200
Max concurrent logins 60 90 120 200
Max concurrent sessions 600 900 1200 2000
Point-in-time-restore Any point last 35 days
Disaster recovery Active Geo-Replication
P1 P2 P4 P6 P11 P15
Max DTUs 125 250 500 1000 1750 4000
Max Database Size (GB) 500 1000
Max in-memory OLTP
storage (GB)1 2 4 8 14 32
Max concurrent workers 200 400 800 1600 2400 6400
Max concurrent logins 200 400 800 1600 2400 6400
Max concurrent sessions 2400 4800 9600 19200 32000 32000
Point-in-time-restore Any point last 35 days
Disaster recovery Active Geo-Replication
Tips for migration
https://www.microsoft.com/en-us/download/details.aspx?id=53595
recommended tool
https://azure.microsoft.com/en-us/documentation/articles/sql-
database-transact-sql-information/
