Azure SQL Pricing Options

• Two Pricing Options for Azure SQL
  • DTU
  • vCore Based
• DTU (Database Tranasaction Unit) is a measure of CPU memory and IO
  • Range of DTU is from 5 to 4000
  • There are tools like DTU Calculator Refer Here where you can run the script or tool on existing on-premise database to arrive to correct amount of DTU
• DTU Has 3 service tiers
  • Basic
    • Uptime SLA: 99.99%
    • Maximum Backup Retention: 7 days
    • CPU: Low
    • IOPS: 1-4 IOPS Per DTU
    • Storage Limit: 2 GB
    • Maximum DTU: 5
  • Standard
    • Uptime SLA: 99.99%
    • Maximum Backup Retention: 35 days
    • CPU: Low, Medium and Hight
    • IOPS: 1-4 IOPS Per DTU
    • Storage Limit: 1 TB
    • Maximum DTU: 3000
  • Premimum
    • Uptime SLA: 99.99%
    • Maximum Backup Retention: 35 days
    • CPU: Medum High
    • IOPS: 25 IOPS Per DTU
    • Storage Limit: 4 TB
    • Maximum DTU: 4000
• Elastic Database pool has eDTU (elastic DTU)
• Azure has provided vCore model which is virtual Cores model

Exercises

• Cloud Essentials Refer Here
• Windows Powershell Refer Here
• Active Directory Refer Here
• Linux Classroom Refer Here
• Watch 1-7 videos of DevOPs Essentials Refer Here