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:
Leave a Comment
All fields are required. Your email address will not be published.
Comments