Successfully added
Azure SQL
by Danny
DTU Purchasing Model for Azure SQL Database
The DTU-based purchasing model uses a database transaction unit (DTU) to calculate and bundle compute costs.
A database transaction unit (DTU) represents a blended measure of
- CPU,
- memory,
- reads, and writes
In the DTU-based purchasing model, you can choose between the basic, standard, and premium service tiers for Azure SQL Database.
Choosing a service tier depends primarily on business continuity, storage, and performance requirements.
Basic | Standard | Premium | |
---|---|---|---|
Target workload | Development and production | Development and production | Development and production |
Uptime SLA | 99.99% | 99.99% | 99.99% |
Maximum backup retention | 7 days | 35 days | 35 days |
CPU | Low | Low, Medium, High | Medium, High |
IOPS (approximate)* | 1-4 IOPS per DTU | 1-4 IOPS per DTU | >25 IOPS per DTU |
IO latency (approximate) | 5 ms (read), 10 ms (write) | 5 ms (read), 10 ms (write) | 2 ms (read/write) |
Columnstore indexing | N/A | S3 and above | Supported |
In-memory OLTP | N/A | N/A | Supported |
Review DTU service tiers to learn more.
Referenced in:
Comments