Azure SQL tiers & pricing
Available Editions
You can list the available editions for a location:
az sql db list-editions -a -o table -l AustraliaEast
Editions: Basic, Standard, Premium or Data Warehouse.
Service Objective:
ElasticPool Basic: Basic Standard: S0, S1, S2, S3, S4, S6, S7, S9 or S12 Premium: P1, P2, P4, P6, P11 or P15 Azure Synapse Analytics: DW100 - DW30000c
Single Databases
Reference: Resource limits for single databases using the DTU purchasing model - Azure SQL Database
| Basic | ||||||
|---|---|---|---|---|---|---|
| Edition | Max DTUs | Storage | Max Storage | Max concurrent workers | Max concurrent sessions | Max in-memory OLTP storage |
| Basic | 5 | 2 | 2 | 30 | 300 | |
| Standard | ||||||
| Edition | Max DTUs | Storage | Max Storage | Max concurrent workers | Max concurrent sessions | Max in-memory OLTP storage |
| S0 | 10 | 250 | 250 | 60 | 600 | |
| S1 | 20 | 250 | 250 | 90 | 900 | |
| S2 | 50 | 250 | 250 | 120 | 1200 | |
| S3 | 100 | 250 | 1024 | 200 | 2400 | |
| S4 | 200 | 250 | 1024 | 400 | 4800 | |
| S6 | 400 | 250 | 1024 | 800 | 9600 | |
| S7 | 800 | 250 | 1024 | 1600 | 19200 | |
| S9 | 1600 | 250 | 1024 | 3200 | 30000 | |
| S12 | 3000 | 250 | 1024 | 6000 | 30000 | |
| Premium | ||||||
| Edition | Max DTUs | Storage | Max Storage | Max concurrent workers | Max concurrent sessions | Max in-memory OLTP storage |
| P1 | 125 | 500 | 1024 | 1 | 200 | 30000 |
| P2 | 250 | 500 | 1024 | 2 | 400 | 30000 |
| P4 | 500 | 500 | 1024 | 4 | 800 | 30000 |
| P6 | 1000 | 500 | 1024 | 8 | 1600 | 30000 |
| P11 | 1750 | 4096 | 4096 | 14 | 2800 | 30000 |
| P15 | 4000 | 4096 | 4096 | 32 | 6400 | 30000 |