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 |