| title | description | services | ms.service | ms.subservice | ms.custom | ms.devlang | ms.topic | author | ms.author | ms.reviewer | manager | ms.date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Azure SQL Database vCore-based resource limits - single database | Microsoft Docs |
This page describes some common vCore-based resource limits for a single database in Azure SQL Database. |
sql-database |
sql-database |
single-database |
conceptual |
CarlRabeler |
carlrab |
craigg |
10/15/2018 |
This article provides the detailed resource limits for Azure SQL Database single databases using the vCore-based purchasing model.
For DTU-based purchasing model limits for single databases on a logical server, see Overview of resource limits on a logical server.
Important
Under some circumstances, you may need to shrink a database to reclaim unused space. For more information, see Manage file space in Azure SQL Database.
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.
| Compute size | GP_Gen4_1 | GP_Gen4_2 | GP_Gen4_4 | GP_Gen4_8 | GP_Gen4_16 | GP_Gen4_24 |
|---|---|---|---|---|---|---|
| H/W generation | 4 | 4 | 4 | 4 | 4 | 4 |
| vCores | 1 | 2 | 4 | 8 | 16 | 24 |
| Memory (GB) | 7 | 14 | 28 | 56 | 112 | 168 |
| Columnstore support | Yes | Yes | Yes | Yes | Yes | Yes |
| In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A | N/A |
| Storage type | Premium (Remote) Storage | Premium (Remote) Storage | Premium (Remote) Storage | Premium (Remote) Storage | Premium (Remote) Storage | Premium (Remote) Storage |
| IO latency (approximate) | 5-7 ms (write) 5-10 ms (read) |
5-7 ms (write) 5-10 ms (read) |
5-7 ms (write) 5-10 ms (read) |
5-7 ms (write) 5-10 ms (read) |
5-7 ms (write) 5-10 ms (read) |
5-7 ms (write) 5-10 ms (read) |
| Max data size (GB) | 1024 | 1024 | 1536 | 3072 | 4096 | 4096 |
| Max log size (GB) | 307 | 307 | 461 | 922 | 1229 | 1229 |
| TempDB size (GB) | 32 | 64 | 128 | 256 | 384 | 384 |
| Target IOPS (64 KB) | 500 | 1000 | 2000 | 4000 | 7000 | 7000 |
| Max concurrent workers (requests) | 200 | 400 | 800 | 1600 | 3200 | 4800 |
| Max allowed sessions | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 |
| Number of replicas | 1 | 1 | 1 | 1 | 1 | 1 |
| Multi-AZ | N/A | N/A | N/A | N/A | N/A | N/A |
| Read Scale-out | N/A | N/A | N/A | N/A | N/A | N/A |
| Included backup storage | 1X DB size | 1X DB size | 1X DB size | 1X DB size | 1X DB size | 1X DB size |
|Compute size|GP_Gen5_2|GP_Gen5_4|GP_Gen5_8|GP_Gen5_16|GP_Gen5_24|GP_Gen5_32|GP_Gen5_40| GP_Gen5_80|
|:--- | --: |--: |--: |--: |---: | --: |--: |--: |--: |
|H/W generation|5|5|5|5|5|5|5|
|vCores|2|4|8|16|24|32|40|80|
|Memory (GB)|11|22|44|88|132|176|220|440|
|Columnstore support|Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
|In-memory OLTP storage (GB)|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|
|Storage type|Premium (Remote) Storage|Premium (Remote) Storage|Premium (Remote) Storage|Premium (Remote) Storage|Premium (Remote) Storage|Premium (Remote) Storage|Premium (Remote) Storage|Premium (Remote) Storage|
|IO latency (approximate)|5-7 ms (write)
5-10 ms (read)|5-7 ms (write)
5-10 ms (read)|5-7 ms (write)
5-10 ms (read)|5-7 ms (write)
5-10 ms (read)|5-7 ms (write)
5-10 ms (read)|5-7 ms (write)
5-10 ms (read)|5-7 ms (write)
5-10 ms (read)|5-7 ms (write)
5-10 ms (read)|
|Max data size (GB)|1024|1024|1536|3072|4096|4096|4096|4096|
|Max log size (GB)|307|307|461|614|1229|1229|1229|1229|
|TempDB size (GB)|64|128|256|384|384|384|384|384|
|Target IOPS (64 KB)|500|1000|2000|4000|6000|7000|7000|7000|
|Max concurrent workers (requests)|200|400|800|1600|2400|3200|4000|8000|
|Max allowed sessions|30000|30000|30000|30000|30000|30000|30000|30000|
|Number of replicas|1|1|1|1|1|1|1|1|
|Multi-AZ|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|
|Read Scale-out|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|
|Included backup storage|1X DB size|1X DB size|1X DB size|1X DB size|1X DB size|1X DB size|1X DB size|1X DB size|
|||
| Compute size | BC_Gen4_1 | BC_Gen4_2 | BC_Gen4_4 | BC_Gen4_8 | BC_Gen4_16 | BC_Gen4_24 |
|---|---|---|---|---|---|---|
| H/W generation | 4 | 4 | 4 | 4 | 4 | 4 |
| vCores | 1 | 2 | 4 | 8 | 16 | 24 |
| Memory (GB) | 7 | 14 | 28 | 56 | 112 | 168 |
| Columnstore support | N/A | N/A | N/A | N/A | N/A | N/A |
| In-memory OLTP storage (GB) | 1 | 2 | 4 | 8 | 20 | 36 |
| Storage type | Local SSD | Local SSD | Local SSD | Local SSD | Local SSD | Local SSD |
| Max data size (GB) | 1024 | 1024 | 1024 | 1024 | 1024 | 1024 |
| Max log size (GB) | 307 | 307 | 307 | 307 | 307 | 307 |
| TempDB size (GB) | 32 | 64 | 128 | 256 | 384 | 384 |
| Target IOPS (64 KB) | 5000 | 10000 | 20000 | 40000 | 80000 | 120000 |
| IO latency (approximate) | 1-2 ms (write) 1-2 ms (read) |
1-2 ms (write) 1-2 ms (read) |
1-2 ms (write) 1-2 ms (read) |
1-2 ms (write) 1-2 ms (read) |
1-2 ms (write) 1-2 ms (read) |
1-2 ms (write) 1-2 ms (read) |
| Max concurrent workers (requests) | 200 | 400 | 800 | 1600 | 3200 | 4800 |
| Max allowed sessions | 30000 | 30000 | 30000 | 30000 | 30000 | 30000 |
| Number of replicas | 3 | 3 | 3 | 3 | 3 | 3 |
| Multi-AZ | N/A | N/A | N/A | N/A | N/A | N/A |
| Read Scale-out | Yes | Yes | Yes | Yes | Yes | Yes |
| Included backup storage | 1X DB size | 1X DB size | 1X DB size | 1X DB size | 1X DB size | 1X DB size |
|Compute size|BC_Gen5_2|BC_Gen5_4|BC_Gen5_8|BC_Gen5_16|BC_Gen5_24|BC_Gen5_32|BC_Gen5_40|BC_Gen5_80|
|:--- | --: |--: |--: |--: |---: | --: |--: |--: |--: |--: |--: |--: |--: |
|H/W generation|5|5|5|5|5|5|5|5|
|vCores|2|4|8|16|24|32|40|80|
|Memory (GB)|11|22|44|88|132|176|220|440|
|Columnstore support|Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
|In-memory OLTP storage (GB)|1.571|3.142|6.284|15.768|25.252|37.936|52.22|131.64|
|Storage type|Local SSD|Local SSD|Local SSD|Local SSD|Local SSD|Local SSD|Local SSD|Local SSD|
|IO latency (approximate)|1-2 ms (write)
1-2 ms (read)|1-2 ms (write)
1-2 ms (read)|1-2 ms (write)
1-2 ms (read)|1-2 ms (write)
1-2 ms (read)|1-2 ms (write)
1-2 ms (read)|1-2 ms (write)
1-2 ms (read)|1-2 ms (write)
1-2 ms (read)|1-2 ms (write)
1-2 ms (read)|
|Max data size (GB)|1024|1024|1024|1024|2048|4096|4096|4096|
|Max log size (GB)|307|307|307|307|614|1229|1229|1229|
|TempDB size (GB)|64|128|256|384|384|384|384|384|
|Target IOPS (64 KB)|5000|10000|20000|40000|60000|80000|100000|200000
|Max concurrent workers (requests)|200|400|800|1600|2400|3200|4000|8000|
|Max allowed sessions|30000|30000|30000|30000|30000|30000|30000|30000|
|Number of replicas|3|3|3|3|3|3|3|3|
|Multi-AZ|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|
|Read Scale-out|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A|
|Included backup storage|1X DB size|1X DB size|1X DB size|1X DB size|1X DB size|1X DB size|1X DB size|1X DB size|
|||
|Performance level|HS_Gen4_1|HS_Gen4_2|HS_Gen4_4|HS_Gen4_8|HS_Gen4_16|HS_Gen4_24| |:--- | --: |--: |--: |--: |--: |--: |--: | |H/W generation|4|4|4|4|4|4| |vCores|1|2|4|8|16|24| |Memory (GB)|7|14|28|56|112|168| |Columnstore support|Yes|Yes|Yes|Yes|Yes|Yes| |In-memory OLTP storage (GB)|N/A|N/A|N/A|N/A|N/A|N/A| |Storage type|Local SSD|Local SSD|Local SSD|Local SSD|Local SSD|Local SSD| |Max data size (TB)|100 |100 |100 |100 |100 |100 | |Max log size (TB)|1 |1 |1 |1 |1 |1 | |TempDB size (GB)|32|64|128|256|384|384| |Target IOPS (64 KB)|To be determined|To be determined|To be determined|To be determined|To be determined|To be determined| |IO latency (approximate)|To be determined|To be determined|To be determined|To be determined|To be determined|To be determined| |Max concurrent workers (requests)|200|400|800|1600|3200|4800| |Max allowed sessions|30000|30000|30000|30000|30000|30000| |Number of replicas|2|2|2|2|2|2| |Multi-AZ|N/A|N/A|N/A|N/A|N/A|N/A| |Read Scale-out|Yes|Yes|Yes|Yes|Yes|Yes| |Included backup storage|7|7|7|7|7|7| |||
|Performance level|HS_Gen5_2|HS_Gen5_4|HS_Gen5_8|HS_Gen5_16|HS_Gen5_24|HS_Gen5_32|HS_Gen5_40|HS_Gen5_80| |:--- | --: |--: |--: |--: |---: | --: |--: |--: |--: |--: |--: |--: |--: | |H/W generation|5|5|5|5|5|5|5|5| |vCores|2|4|8|16|24|32|40|80| |Memory (GB)|11|22|44|88|132|176|220|440| |Columnstore support|Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes| |In-memory OLTP storage (GB)|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A| |Storage type|Local SSD|Local SSD|Local SSD|Local SSD|Local SSD|Local SSD|Local SSD|Local SSD| |Max data size (TB)|100 |100 |100 |100 |100 |100 |100 |100 | |Max log size (TB)|1 |1 |1 |1 |1 |1 |1 |1 | |TempDB size (GB)|64|128|256|384|384|384|384|384| |Target IOPS (64 KB)|To be determined|To be determined|To be determined|To be determined|To be determined|To be determined|To be determined|To be determined| |IO latency (approximate)|To be determined|To be determined|To be determined|To be determined|To be determined|To be determined|To be determined|To be determined| |Max concurrent workers (requests)|200|400|800|1600|2400|3200|4000|8000| |Max allowed sessions|30000|30000|30000|30000|30000|30000|30000|30000| |Number of replicas|2|2|2|2|2|2|2|2| |Multi-AZ|N/A|N/A|N/A|N/A|N/A|N/A|N/A|N/A| |Read Scale-out|Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes| |Included backup storage (preview limit)|7|7|7|7|7|7|7|7| |||
- See SQL Database FAQ for answers to frequently asked questions.
- For information about general Azure limits, see Azure subscription and service limits, quotas, and constraints.