Resource limits for single databases using the DTU-based purchasing model

This article provides the detailed resource limits for Azure SQL Database single databases using the DTU-based purchasing model.

For DTU-based purchasing model resource limits for elastic pools, see DTU-based resource limits - elastic pools. For vCore-based resource limits, see vCore-based resource limits - single databases and vCore-based resource limits - elastic pools. For more information regarding the different purchasing models, see Purchasing models and service tiers.

Single database: Storage sizes and compute sizes

The following tables show the resources available for a single database at each service tier and compute size. You can set the service tier, compute size, and storage amount for a single database using the Azure portal, Transact-SQL, PowerShell, the Azure CLI, or the REST API.

Important

For scaling guidance and considerations, see Scale a single database

Basic service tier

Compute size Basic
Max DTUs 5
Included storage (GB) 2
Max storage choices (GB) 2
Max in-memory OLTP storage (GB) N/A
Max concurrent workers (requests) 30
Max concurrent sessions 300

Standard service tier

Compute size S0 S1 S2 S3
Max DTUs 10 20 50 100
Included storage (GB) 250 250 250 250
Max storage choices (GB) 250 250 250 250, 500, 750, 1024
Max in-memory OLTP storage (GB) N/A N/A N/A N/A
Max concurrent workers (requests) 60 90 120 200
Max concurrent sessions 600 900 1200 2400

Standard service tier (continued)

Compute size S4 S6 S7 S9 S12
Max DTUs 200 400 800 1600 3000
Included storage (GB) 250 250 250 250 250
Max storage choices (GB) 250, 500, 750, 1024 250, 500, 750, 1024 250, 500, 750, 1024 250, 500, 750, 1024 250, 500, 750, 1024
Max in-memory OLTP storage (GB) N/A N/A N/A N/A N/A
Max concurrent workers (requests) 400 800 1600 3200 6000
Max concurrent sessions 4800 9600 19200 30000 30000

Premium service tier

Compute size P1 P2 P4 P6 P11 P15
Max DTUs 125 250 500 1000 1750 4000
Included storage (GB) 500 500 500 500 4096* 4096*
Max storage choices (GB) 500, 750, 1024 500, 750, 1024 500, 750, 1024 500, 750, 1024 4096* 4096*
Max in-memory OLTP storage (GB) 1 2 4 8 14 32
Max concurrent workers (requests) 200 400 800 1600 2400 6400
Max concurrent sessions 30000 30000 30000 30000 30000 30000

* From 1024 GB up to 4096 GB in increments of 256 GB

Important

More than 1 TB of storage in the Premium tier is currently available in all regions except: China East, China North, Germany Central, Germany Northeast, West Central US, US DoD regions, and US Government Central. In these regions, the storage max in the Premium tier is limited to 1 TB. For more information, see P11-P15 current limitations.

Note

For tempdb limits, see tempdb limits.

Next steps