SQL VM

• IaaS option - SQL server running on a VM in the cloud.
• You manage patching, etc.
• Agent extension to move it closer to Paas/Can be upgraded to full later on
  • Lightweight mode (Inventory/Change SKUs)
  • Full mode
    • Auto patch
    • storage
    • azure backup
    • key vault for secret management
    • HA

SQL Managed Instance

• PaaS offering
• In your [[202404121703 Azure VNet|VNet]]
• Multiple DBs per instance

SQL DB

• Full PaaS - serverless
• Deployment Modes
  • Single DB
  • Elastic Pool
    • collection of single DBs with shared resources like CPU, etc.
• Purchasing models
  • vCore based
    • Tiers:
      • General purpose
      • Enterprise
      • Hyperscale
  • DTU based (older style)
    • Tiers:
      • Basic
      • Standard
      • Premium

Service tiers

• For both managed and azure sql db
• For both we can specify zone-
• Lives under a logical DB server
  • We can specify network, auditing, etc. in there

Standard

• primary (data is stored separately)
• if primary goes down, secondary is brought online connects to the data source and starts working
• expected to be a bit of downtime

Premium/Business critical

• primary (data and logs are stored with it)
• primary replicates to a set of secondaries

---

references:

Azure SQL overview SQL VM and Agent extension Feature comparison