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.

Comments