Resource limits for single databases using the vCore purchasing model
Applies to:
Azure SQL Database
This article provides the detailed resource limits for single databases in Azure SQL Database using the vCore purchasing model.
- For elastic pool vCore resource limits, vCore resource limits - elastic pools.
- For limits of the logical server in Azure, see Overview of resource limits on a server.
- For DTU purchasing model resource limits, see DTU resource limits single databases and DTU resource limits elastic pools.
- For more information regarding the different purchasing models, see Purchasing models and service tiers.
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.
- For scaling guidance and considerations, see Scale a single database.
Each read-only replica of a database has its own resources, such as vCores, memory, data IOPS, tempdb
, workers, and sessions. Each read-only replica is subject to the resource limits detailed later in this article.
You can set the service tier, compute size (service objective), and storage amount for a single database using:
Note
The Gen5 hardware in the vCore purchasing model has been renamed to standard-series (Gen5).
General purpose - serverless compute - standard-series (Gen5)
The serverless compute tier is currently available on standard-series (Gen5) hardware only.
General Purpose Serverless Standard-series (Gen5) compute (part 1 of 3)
Compute size (service objective) | GP_S_Gen5_1 | GP_S_Gen5_2 | GP_S_Gen5_4 | GP_S_Gen5_6 | GP_S_Gen5_8 |
---|---|---|---|---|---|
Hardware | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
Min-max vCores | 0.5 - 1 | 0.5 - 2 | 0.5 - 4 | 0.75 - 6 | 1.0 - 8 |
Min-max memory (GB) | 2.02 - 3 | 2.05 - 6 | 2.10 - 12 | 2.25 - 18 | 3.00 - 24 |
Min-max auto-pause delay (minutes) | 60 - 10,080 | 60 - 10,080 | 60 - 10,080 | 60 - 10,080 | 60 - 10,080 |
Columnstore support | Yes 1 | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (GB) | 512 | 1024 | 1024 | 1024 | 2048 |
Max log size (GB) 2 | 154 | 307 | 307 | 307 | 614 |
Tempdb max data size (GB) | 32 | 64 | 128 | 192 | 256 |
Storage type | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD |
Read IO latency (approximate) | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms |
Write IO latency (approximate) | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms |
Max data IOPS 3 | 320 | 640 | 1280 | 1920 | 2560 |
Max log rate (MBps) | 4.5 | 9 | 18 | 27 | 36 |
Max concurrent workers | 75 | 150 | 300 | 450 | 600 |
Max concurrent external connections 4 | 7 | 15 | 30 | 45 | 60 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 1 | 1 | 1 | 1 | 1 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes |
Read Scale-out | 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 |
1 Service objectives with smaller max vCore configurations may have insufficient memory for creating and using columnstore indexes. If encountering performance problems with columnstore, increase the max vCore configuration to increase the max memory available.
2 For documented max data size values. Reducing max data size reduces max log size proportionally.
3 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
4 See External Connections for additional details on what counts as an external connection.
General Purpose Serverless Standard-series (Gen5) compute (part 2 of 3)
Compute size (service objective) | GP_S_Gen5_10 | GP_S_Gen5_12 | GP_S_Gen5_14 | GP_S_Gen5_16 | GP_S_Gen5_18 |
---|---|---|---|---|---|
Hardware | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
Min-max vCores | 1.25-10 | 1.50-12 | 1.75-14 | 2.00-16 | 2.25-18 |
Min-max memory (GB) | 3.75-30 | 4.50-36 | 5.25-42 | 6.00-48 | 6.75-54 |
Min-max auto-pause delay (minutes) | 60-10,080 | 60-10,080 | 60-10,080 | 60-10,080 | 60-10,080 |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (GB) | 2048 | 3072 | 3072 | 3072 | 3072 |
Max log size (GB) 1 | 614 | 922 | 922 | 922 | 922 |
Tempdb max data size (GB) | 320 | 384 | 448 | 512 | 576 |
Storage type | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD |
Read IO latency (approximate) | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms |
Write IO latency (approximate) | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms |
Max data IOPS 2 | 3200 | 3840 | 4480 | 5120 | 5760 |
Max log rate (MBps) | 45 | 50 | 50 | 50 | 50 |
Max concurrent workers | 750 | 900 | 1050 | 1200 | 1350 |
Max concurrent external connections 3 | 75 | 90 | 105 | 120 | 135 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 1 | 1 | 1 | 1 | 1 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes |
Read Scale-out | 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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
General Purpose Standard-series Serverless (Gen5) compute (part 3 of 3)
Compute size (service objective) | GP_S_Gen5_20 | GP_S_Gen5_24 | GP_S_Gen5_32 | GP_S_Gen5_40 | GP_S_Gen5_80 3 |
---|---|---|---|---|---|
Hardware | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
Min-max vCores | 2.5-20 | 3-24 | 4-32 | 5-40 | 10-80 |
Min-max memory (GB) | 7.5-60 | 9-72 | 12-96 | 15-120 | 30-240 |
Min-max auto-pause delay (minutes) | 60-10,080 | 60-10,080 | 60-10,080 | 60-10,080 | 60-10,080 |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (GB) | 3072 | 4096 | 4096 | 4096 | 4096 |
Max log size (GB) 1 | 922 | 1024 | 1024 | 1024 | 1024 |
Tempdb max data size (GB) | 640 | 768 | 1024 | 1280 | 2560 |
Storage type | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD |
Read IO latency (approximate) | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms |
Write IO latency (approximate) | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms |
Max data IOPS 2 | 6,400 | 7,680 | 10,240 | 12,800 | 12,800 |
Max log rate (MBps) | 50 | 50 | 50 | 50 | 50 |
Max concurrent workers | 1500 | 1800 | 2400 | 3000 | 6000 |
Max concurrent external connections 4 | 150 | 150 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 1 | 1 | 1 | 1 | 1 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes |
Read Scale-out | 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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 For specific regions where 80 max vcores in serverless is available, see Available regions.
4 See External Connections for additional details on what counts as an external connection.
Hyperscale - serverless compute - Gen 5
The serverless compute tier is currently available on Gen5 hardware only.
Gen5 compute generation (part 1 of 2)
Compute size (service objective) | HS_S_Gen5_2 | HS_S_Gen5_4 | HS_S_Gen5_6 | HS_S_Gen5_8 | HS_S_Gen5_10 | HS_S_Gen5_12 | HS_S_Gen5_14 |
---|---|---|---|---|---|---|---|
Compute generation | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
Min-max vCores | 0.5-2 | 0.5-4 | 0.75-6 | 1-8 | 1.25-10 | 1.5-12 | 1.75-14 |
Min-max memory (GB) | 2.05-6 | 2.10-12 | 2.25-18 | 3.00-24 | 3.75-30 | 4.50-36 | 5.25-42 |
Max RBPEX Size | N/A | N/A | N/A | N/A | N/A | N/A | N/A |
Columnstore support | 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 |
Max data size (TB) | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 64 | 128 | 192 | 256 | 320 | 384 | 448 |
Storage type | Multi-tiered 1 | Multi-tiered 1 | Multi-tiered 1 | Multi-tiered 1 | Multi-tiered 1 | Multi-tiered 1 | Multi-tiered 1 |
Max local SSD IOPS 2 | 8000 | 16000 | 24000 | 32000 | 40000 | 48000 | 56000 |
Max log rate (MBps) | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
IO latency (approximate) | Variable 3 | Variable 3 | Variable 3 | Variable 3 | Variable 3 | Variable 3 | Variable 3 |
Max concurrent workers | 150 | 300 | 450 | 600 | 750 | 900 | 1050 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | Available in preview | Available in preview | Available in preview | Available in preview | Available in preview | Available in preview | Available in preview |
Read Scale-out | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days | 7 days | 7 days | 7 days |
1 Hyperscale is a multi-tiered architecture with separate compute and storage components. Review Hyperscale service tier for more information.
2 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
3 Latency is 1-2 ms for data on local compute replica SSD, which caches most used data pages. Higher latency for data retrieved from page servers.
Gen5 compute generation (part 2 of 2)
Compute size (service objective) | HS_S_Gen5_16 | HS_S_Gen5_18 | HS_S_Gen5_20 | HS_S_Gen5_24 | HS_S_Gen5_32 | HS_S_Gen5_40 | HS_S_Gen5_80 |
---|---|---|---|---|---|---|---|
Compute generation | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
Min-max vCores | 2-16 | 2.25-18 | 2.25-20 | 3-24 | 4-32 | 5-40 | 10-80 |
Min-max memory (GB) | 6.00-48 | 6.75-54 | 7.5-60 | 9-72 | 12-96 | 15-120 | 30-240 |
Max RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
Columnstore support | 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 |
Max data size (TB) | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 512 | 576 | 640 | 768 | 1024 | 1280 | 2560 |
Storage type | Multi-tiered 1 | Multi-tiered 1 | Multi-tiered 1 | Multi-tiered 1 | Multi-tiered 1 | Multi-tiered 1 | Multi-tiered 1 |
Max local SSD IOPS 2 | 64000 | 72000 | 80000 | 96000 | 128000 | 160000 | 204800 |
Max log rate (MBps) | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
IO latency (approximate) | Variable 3 | Variable 3 | Variable 3 | Variable 3 | Variable 3 | Variable 3 | Variable 3 |
Max concurrent workers | 1200 | 1350 | 1500 | 1800 | 2400 | 3000 | 6000 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | Available in preview | Available in preview | Available in preview | Available in preview | Available in preview | Available in preview | Available in preview |
Read Scale-out | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days | 7 days | 7 days | 7 days |
1 Hyperscale is a multi-tiered architecture with separate compute and storage components. Review Hyperscale service tier for more information.
2 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
3 Latency is 1-2 ms for data on local compute replica SSD, which caches most used data pages. Higher latency for data retrieved from page servers.
Hyperscale - provisioned compute - standard-series (Gen5)
Hyperscale Standard-series (Gen5) compute generation (part 1 of 2)
Compute size (service objective) | HS_Gen5_2 | HS_Gen5_4 | HS_Gen5_6 | HS_Gen5_8 | HS_Gen5_10 | HS_Gen5_12 | HS_Gen5_14 |
---|---|---|---|---|---|---|---|
Hardware | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
vCores | 2 | 4 | 6 | 8 | 10 | 12 | 14 |
Memory (GB) | 10.4 | 20.8 | 31.1 | 41.5 | 51.9 | 62.3 | 72.7 |
RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
Columnstore support | 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 |
Max data size (TB) | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) |
64 | 128 | 192 | 256 | 320 | 384 | 448 |
Max local SSD IOPS 1 | 8000 | 16,000 | 24,000 | 32,000 | 40,000 | 48,000 | 56,000 |
Max log rate (MBps) | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Local read IO latency2 | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Remote read IO latency2 | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms |
Write IO latency2 | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms |
Storage type | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 |
Max concurrent workers | 200 | 400 | 600 | 800 | 1000 | 1200 | 1400 |
Max concurrent external connections 4 | 20 | 40 | 60 | 80 | 100 | 120 | 140 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Read Scale-out | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days | 7 days | 7 days | 7 days |
1 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
2 Latency numbers are approximate and representative for typical workloads at steady state, but are not guaranteed.
3 Hyperscale is a multi-tiered architecture with separate compute and storage components. For more information, see Hyperscale service tier architecture.
4 See External Connections for additional details on what counts as an external connection.
Hyperscale Standard-series (Gen5) compute generation (part 2 of 2)
Compute size (service objective) | HS_Gen5_16 | HS_Gen5_18 | HS_Gen5_20 | HS_Gen5_24 | HS_Gen5_32 | HS_Gen5_40 | HS_Gen5_80 |
---|---|---|---|---|---|---|---|
Hardware | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
vCores | 16 | 18 | 20 | 24 | 32 | 40 | 80 |
Memory (GB) | 83 | 93.4 | 103.8 | 124.6 | 166.1 | 207.6 | 415.2 |
RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
Columnstore support | 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 |
Max data size (TB) | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 512 | 576 | 640 | 768 | 1024 | 1280 | 2560 |
Max local SSD IOPS 1 | 64,000 | 72,000 | 80,000 | 96,000 | 128,000 | 160,000 | 204,800 |
Max log rate (MBps) | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Local read IO latency2 | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Remote read IO latency2 | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms |
Write IO latency2 | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms |
Storage type | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 |
Max concurrent workers | 1600 | 1800 | 2000 | 2400 | 3200 | 4000 | 8000 |
Max concurrent external connections 4 | 150 | 150 | 150 | 150 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Read Scale-out | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days | 7 days | 7 days | 7 days |
1 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
2 Latency numbers are representative for typical workloads at steady state, but are not guaranteed.
3 Hyperscale is a multi-tiered architecture with separate compute and storage components. For more information, see Hyperscale service tier architecture.
4 See External Connections for additional details on what counts as an external connection.
Hyperscale - provisioned compute - DC-series
Compute size (service objective) | HS_DC_2 | HS_DC_4 | HS_DC_6 | HS_DC_8 |
---|---|---|---|---|
Hardware | DC-series | DC-series | DC-series | DC-series |
vCores | 2 | 4 | 6 | 8 |
Memory (GB) | 9 | 18 | 27 | 36 |
RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
Columnstore support | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A |
Max data size (TB) | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 64 | 128 | 192 | 256 |
Max local SSD IOPS 1 | 14,000 | 28,000 | 42,000 | 44,800 |
Max log rate (MBps) | 100 | 100 | 100 | 100 |
Local read IO latency2 | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Remote read IO latency2 | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms |
Write IO latency2 | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms |
Storage type | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 |
Max concurrent workers | 160 | 320 | 480 | 640 |
Max concurrent external connections 4 | 16 | 32 | 48 | 64 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | N/A | N/A | N/A | N/A |
Read Scale-out | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days |
1 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
2 Latency numbers are representative for typical workloads at steady state, but are not guaranteed.
3 Hyperscale is a multi-tiered architecture with separate compute and storage components. For more information, see Hyperscale service tier architecture.
4 See External Connections for additional details on what counts as an external connection.
Hyperscale - Premium-series
Hyperscale - Premium-series (part 1 of 3)
SLOs in the Hyperscale premium-series tier use the naming convention HS_PRMS_
followed by the number of vCores, for example, HS_PRMS_10
.
vCores | 2 | 4 | 6 | 8 | 10 |
---|---|---|---|---|---|
Hardware | Premium-series | Premium-series | Premium-series | Premium-series | Premium-series |
Memory (GB) | 10.4 | 20.8 | 31.1 | 41.5 | 51.9 |
RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (TB) | 100 | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 64 | 128 | 192 | 256 | 320 |
Max local SSD IOPS 1 | 8,000 | 16,000 | 24,000 | 32,000 | 40,000 |
Max log rate (MBps) | 100 | 100 | 100 | 100 | 100 |
Local read IO latency2 | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Remote read IO latency2 | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms |
Write IO latency2 | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms |
Storage type | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 |
Max concurrent workers | 200 | 400 | 600 | 800 | 1000 |
Max concurrent external connections 4 | 20 | 40 | 60 | 80 | 100 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | N/A | N/A | N/A | N/A | N/A |
Read Scale-out | Yes | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days | 7 days |
1 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
2 Latency numbers are representative for typical workloads at steady state, but are not guaranteed.
3 Hyperscale is a multi-tiered architecture with separate compute and storage components. For more information, see Hyperscale service tier architecture.
4 See External Connections for additional details on what counts as an external connection.
Hyperscale - Premium-series (part 2 of 3)
SLOs in the Hyperscale premium-series tier use the naming convention HS_PRMS_
followed by the number of vCores, for example, HS_PRMS_10
.
vCores | 12 | 14 | 16 | 18 | 20 |
---|---|---|---|---|---|
Hardware | Premium-series | Premium-series | Premium-series | Premium-series | Premium-series |
Memory (GB) | 62.3 | 72.7 | 83.0 | 93.4 | 103.8 |
RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (TB) | 100 | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 384 | 448 | 512 | 576 | 640 |
Max local SSD IOPS 1 | 48,000 | 56,000 | 64,000 | 72,000 | 80,000 |
Max log rate (MBps) | 100 | 100 | 100 | 100 | 100 |
Local read IO latency2 | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Remote read IO latency2 | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms |
Write IO latency2 | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms |
Storage type | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 |
Max concurrent workers | 1,200 | 1,400 | 1,600 | 1,800 | 2,000 |
Max concurrent external connections 4 | 120 | 140 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | N/A | N/A | N/A | N/A | N/A |
Read Scale-out | Yes | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days | 7 days |
1 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
2 Latency numbers are representative for typical workloads at steady state, but are not guaranteed.
3 Hyperscale is a multi-tiered architecture with separate compute and storage components. For more information, see Hyperscale service tier architecture.
4 See External Connections for additional details on what counts as an external connection.
Hyperscale - Premium-series (part 3 of 3)
SLOs in the Hyperscale premium-series tier use the naming convention HS_PRMS_
followed by the number of vCores, for example, HS_PRMS_10
.
vCores | 24 | 32 | 40 | 80 | 128 |
---|---|---|---|---|---|
Memory (GB) | 124.6 | 166.1 | 207.6 | 415.2 | 625 |
RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (TB) | 100 | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 768 | 1024 | 1280 | 2560 | 4096 |
Max local SSD IOPS 1 | 96,000 | 128,000 | 160,000 | 320,000 | 327,680 |
Max log rate (MBps) | 100 | 100 | 100 | 100 | 100 |
Local read IO latency2 | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Remote read IO latency2 | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms |
Write IO latency2 | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms |
Storage type | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 |
Max concurrent workers | 2,400 | 3,200 | 4,000 | 8,000 | 12,800 |
Max concurrent external connections 4 | 150 | 150 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | N/A | N/A | N/A | N/A | N/A |
Read Scale-out | Yes | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days | 7 days |
1 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
2 Latency numbers are representative for typical workloads at steady state, but are not guaranteed.
3 Hyperscale is a multi-tiered architecture with separate compute and storage components. For more information, see Hyperscale service tier architecture.
4 See External Connections for additional details on what counts as an external connection.
Hyperscale - Premium-series memory optimized
Hyperscale - Premium-series memory optimized (part 1 of 3)
SLOs in the Premium-series memory optimized tier use the naming convention HS_MOPRMS_
followed by the number of vCores, for example, HS_MOPRMS_10
.
vCores | 2 | 4 | 6 | 8 | 10 |
---|---|---|---|---|---|
Hardware | Premium-series | Premium-series | Premium-series | Premium-series | Premium-series |
Memory (GB) | 20.8 | 41.5 | 62.3 | 83 | 103.8 |
RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (TB) | 100 | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 64 | 128 | 192 | 256 | 320 |
Max local SSD IOPS 1 | 10,240 | 20,480 | 30,720 | 40,960 | 51,200 |
Max log rate (MBps) | 100 | 100 | 100 | 100 | 100 |
Local read IO latency2 | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Remote read IO latency2 | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms |
Write IO latency2 | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms |
Storage type | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 |
Max concurrent workers | 200 | 400 | 600 | 800 | 1000 |
Max concurrent external connections 4 | 20 | 40 | 60 | 80 | 100 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | N/A | N/A | N/A | N/A | N/A |
Read Scale-out | Yes | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days | 7 days |
1 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
2 Latency numbers are representative for typical workloads at steady state, but are not guaranteed.
3 Hyperscale is a multi-tiered architecture with separate compute and storage components. For more information, see Hyperscale service tier architecture.
4 See External Connections for additional details on what counts as an external connection.
Hyperscale - Premium-series memory optimized (part 2 of 3)
SLOs in the Premium-series memory optimized tier use the naming convention HS_MOPRMS_
followed by the number of vCores, for example, HS_MOPRMS_10
.
vCores | 12 | 14 | 16 | 18 | 20 |
---|---|---|---|---|---|
Hardware | Premium-series | Premium-series | Premium-series | Premium-series | Premium-series |
Memory (GB) | 124.6 | 145.3 | 166.1 | 186.9 | 207.6 |
RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (TB) | 100 | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 384 | 448 | 512 | 576 | 640 |
Max local SSD IOPS 1 | 61,440 | 71,680 | 81,920 | 92,160 | 102,400 |
Max log rate (MBps) | 100 | 100 | 100 | 100 | 100 |
Local read IO latency2 | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Remote read IO latency2 | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms |
Write IO latency2 | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms |
Storage type | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 |
Max concurrent workers | 1,200 | 1,400 | 1,600 | 1,800 | 2,000 |
Max concurrent external connections 4 | 120 | 140 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | N/A | N/A | N/A | N/A | N/A |
Read Scale-out | Yes | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days | 7 days |
1 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
2 Latency numbers are representative for typical workloads at steady state, but are not guaranteed.
3 Hyperscale is a multi-tiered architecture with separate compute and storage components. For more information, see Hyperscale service tier architecture.
4 See External Connections for additional details on what counts as an external connection.
Hyperscale - Premium-series memory optimized (part 3 of 3)
SLOs in the Premium-series memory optimized tier use the naming convention HS_MOPRMS_
followed by the number of vCores, for example, HS_MOPRMS_10
.
vCores | 24 | 32 | 40 | 80 |
---|---|---|---|---|
Memory (GB) | 249.1 | 332.2 | 415.2 | 830.5 |
RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
Columnstore support | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A |
Max data size (TB) | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 768 | 1024 | 1280 | 2560 |
Max local SSD IOPS 1 | 122,880 | 163,840 | 204,800 | 327,680 |
Max log rate (MBps) | 100 | 100 | 100 | 100 |
Local read IO latency2 | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Remote read IO latency2 | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms |
Write IO latency2 | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms |
Storage type | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 |
Max concurrent workers | 2,400 | 3,200 | 4,000 | 8,000 |
Max concurrent external connections 4 | 150 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | N/A | N/A | N/A | N/A |
Read Scale-out | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days |
1 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
2 Latency numbers are representative for typical workloads at steady state, but are not guaranteed.
3 Hyperscale is a multi-tiered architecture with separate compute and storage components. For more information, see Hyperscale service tier architecture.
4 See External Connections for additional details on what counts as an external connection.
General purpose - provisioned compute - standard-series (Gen5)
General purpose Standard-series (Gen5) compute (part 1 of 3)
Compute size (service objective) | GP_Gen5_2 | GP_Gen5_4 | GP_Gen5_6 | GP_Gen5_8 | GP_Gen5_10 |
---|---|---|---|---|---|
Hardware | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
vCores | 2 | 4 | 6 | 8 | 10 |
Memory (GB) | 10.4 | 20.8 | 31.1 | 41.5 | 51.9 |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (GB) | 1024 | 1024 | 1536 | 2048 | 2048 |
Max log size (GB) 1 | 307 | 307 | 461 | 461 | 461 |
Tempdb max data size (GB) | 64 | 128 | 192 | 256 | 320 |
Storage type | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD |
Read IO latency (approximate) | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms |
Write IO latency (approximate) | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms |
Max data IOPS 2 | 640 | 1280 | 1920 | 2560 | 3200 |
Max log rate (MBps) | 9 | 18 | 27 | 36 | 45 |
Max concurrent workers | 200 | 400 | 600 | 800 | 1000 |
Max concurrent external connections 3 | 20 | 40 | 60 | 80 | 100 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 1 | 1 | 1 | 1 | 1 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes |
Read Scale-out | 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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
General purpose Standard-series (Gen5) compute (part 2 of 3)
Compute size (service objective) | GP_Gen5_12 | GP_Gen5_14 | GP_Gen5_16 | GP_Gen5_18 | GP_Gen5_20 |
---|---|---|---|---|---|
Hardware | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
vCores | 12 | 14 | 16 | 18 | 20 |
Memory (GB) | 62.3 | 72.7 | 83 | 93.4 | 103.8 |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (GB) | 3072 | 3072 | 3072 | 3072 | 3072 |
Max log size (GB) 1 | 922 | 922 | 922 | 922 | 922 |
Tempdb max data size (GB) | 384 | 384 | 512 | 576 | 640 |
Storage type | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD |
Read IO latency (approximate) | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms |
Write IO latency (approximate) | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms |
Max data IOPS 2 | 3,840 | 4,480 | 5,120 | 5,760 | 6,400 |
Max log rate (MBps) | 50 | 50 | 50 | 50 | 50 |
Max concurrent workers | 1,200 | 1,400 | 1,600 | 1,800 | 2,000 |
Max concurrent external connections 3 | 120 | 140 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 1 | 1 | 1 | 1 | 1 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes |
Read Scale-out | 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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
General purpose Standard-series (Gen5) compute (part 3 of 3)
Compute size (service objective) | GP_Gen5_24 | GP_Gen5_32 | GP_Gen5_40 | GP_Gen5_80 | GP_Gen5_128 |
---|---|---|---|---|---|
Hardware | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
vCores | 24 | 32 | 40 | 80 | 1284 |
Memory (GB) | 124.6 | 166.1 | 207.6 | 415.2 | 625 |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (GB) | 4096 | 4096 | 4096 | 4096 | 4096 |
Max log size (GB) 1 | 1024 | 1024 | 1024 | 1024 | 1024 |
Tempdb max data size (GB) | 768 | 1024 | 1280 | 2560 | 2560 |
Storage type | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD |
Read IO latency (approximate) | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms |
Write IO latency (approximate) | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms |
Max data IOPS 2 | 7,680 | 10,240 | 12,800 | 12,800 | 16,000 |
Max log rate (MBps) | 50 | 50 | 50 | 50 | 50 |
Max concurrent workers | 2,400 | 3,200 | 4,000 | 8,000 | 12,800 |
Max concurrent external connections 3 | 150 | 150 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 1 | 1 | 1 | 1 | 1 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes |
Read Scale-out | 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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
4 The 128 vCore offering is currently in preview.
General purpose - provisioned compute - Fsv2-series
General Purpose Fsv2-series Hardware (part 1 of 2)
Compute size (service objective) | GP_Fsv2_8 | GP_Fsv2_10 | GP_Fsv2_12 | GP_Fsv2_14 | GP_Fsv2_16 |
---|---|---|---|---|---|
Hardware | Fsv2-series | Fsv2-series | Fsv2-series | Fsv2-series | Fsv2-series |
vCores | 8 | 10 | 12 | 14 | 16 |
Memory (GB) | 15.1 | 18.9 | 22.7 | 26.5 | 30.2 |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A | N/A |
Max data size (GB) | 1024 | 1024 | 1024 | 1024 | 1536 |
Max log size (GB) 1 | 336 | 336 | 336 | 336 | 512 |
Tempdb max data size (GB) | 37 | 46 | 56 | 65 | 74 |
Storage type | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD |
Read IO latency (approximate) | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms |
Write IO latency (approximate) | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms |
Max data IOPS 2 | 2560 | 3200 | 3840 | 4480 | 5120 |
Max log rate (MBps) | 36 | 45 | 50 | 50 | 50 |
Max concurrent workers | 400 | 500 | 600 | 700 | 800 |
Max concurrent logins | 800 | 1000 | 1200 | 1400 | 1600 |
Max concurrent external connections 3 | 40 | 50 | 60 | 70 | 80 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 1 | 1 | 1 | 1 | 1 |
Multi-AZ | N/A | N/A | N/A | N/A | N/A |
Read Scale-out | 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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
General Purpose Fsv2-series hardware (part 2 of 2)
Compute size (service objective) | GP_Fsv2_18 | GP_Fsv2_20 | GP_Fsv2_24 | GP_Fsv2_32 | GP_Fsv2_36 | GP_Fsv2_72 |
---|---|---|---|---|---|---|
Hardware | Fsv2-series | Fsv2-series | Fsv2-series | Fsv2-series | Fsv2-series | Fsv2-series |
vCores | 18 | 20 | 24 | 32 | 36 | 72 |
Memory (GB) | 34.0 | 37.8 | 45.4 | 60.5 | 68.0 | 136.0 |
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 |
Max data size (GB) | 1536 | 1536 | 1536 | 3072 | 3072 | 4096 |
Max log size (GB) 1 | 512 | 512 | 512 | 1024 | 1024 | 1024 |
Tempdb max data size (GB) | 83 | 93 | 111 | 148 | 167 | 333 |
Storage type | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD |
Read IO latency (approximate) | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms |
Write IO latency (approximate) | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms |
Max data IOPS 2 | 5760 | 6400 | 7680 | 10,240 | 11,520 | 12,800 |
Max log rate (MBps) | 50 | 50 | 50 | 50 | 50 | 50 |
Max concurrent workers | 900 | 1000 | 1200 | 1600 | 1800 | 3600 |
Max concurrent logins | 1800 | 2000 | 2400 | 3200 | 3600 | 7200 |
Max concurrent external connections 3 | 90 | 100 | 120 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
General purpose - provisioned compute - DC-series
Compute size (service objective) | GP_DC_2 | GP_DC_4 | GP_DC_6 | GP_DC_8 |
---|---|---|---|---|
Hardware | DC-series | DC-series | DC-series | DC-series |
vCores | 2 | 4 | 6 | 8 |
Memory (GB) | 9 | 18 | 27 | 36 |
Columnstore support | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | N/A | N/A | N/A | N/A |
Max data size (GB) | 1024 | 1536 | 3072 | 3072 |
Max log size (GB) 1 | 307 | 461 | 922 | 922 |
Tempdb max data size (GB) | 64 | 128 | 192 | 256 |
Storage type | Remote SSD | Remote SSD | Remote SSD | Remote SSD |
Read IO latency (approximate) | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms |
Write IO latency (approximate) | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms |
Max data IOPS 2 | 640 | 1280 | 1920 | 2560 |
Max log rate (MBps) | 9 | 18 | 27 | 36 |
Max concurrent workers | 160 | 320 | 480 | 640 |
Max concurrent external connections 3 | 16 | 32 | 48 | 64 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 1 | 1 | 1 | 1 |
Multi-AZ | N/A | N/A | N/A | N/A |
Read Scale-out | N/A | N/A | N/A | N/A |
Included backup storage | 1X DB size | 1X DB size | 1X DB size | 1X DB size |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
Business critical - provisioned compute - standard-series (Gen5)
Business critical Standard-series (Gen5) compute generation (part 1 of 3)
Compute size (service objective) | BC_Gen5_2 | BC_Gen5_4 | BC_Gen5_6 | BC_Gen5_8 | BC_Gen5_10 |
---|---|---|---|---|---|
Hardware | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
vCores | 2 | 4 | 6 | 8 | 10 |
Memory (GB) | 10.4 | 20.8 | 31.1 | 41.5 | 51.9 |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | 1.57 | 3.14 | 4.71 | 6.28 | 8.65 |
Max data size (GB) | 1024 | 1024 | 1536 | 2048 | 2048 |
Max log size (GB) 1 | 307 | 307 | 461 | 461 | 461 |
Tempdb max data size (GB) | 64 | 128 | 192 | 256 | 320 |
Max local storage size (GB) | 4829 | 4829 | 4829 | 4829 | 4829 |
Storage type | Local SSD | Local SSD | Local SSD | Local SSD | Local SSD |
Read IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Write IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Max data IOPS 2 | 8000 | 16,000 | 24,000 | 32,000 | 40,000 |
Max log rate (MBps) | 24 | 48 | 72 | 96 | 96 |
Max concurrent workers | 200 | 400 | 600 | 800 | 1000 |
Max concurrent logins | 200 | 400 | 600 | 800 | 1000 |
Max concurrent external connections 3 | 20 | 40 | 60 | 80 | 100 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 4 | 4 | 4 | 4 | 4 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes |
Read Scale-out | Yes | Yes | Yes | Yes | Yes |
Included backup storage | 1X DB size | 1X DB size | 1X DB size | 1X DB size | 1X DB size |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
Business critical Standard-series (Gen5) compute generation (part 2 of 3)
Compute size (service objective) | BC_Gen5_12 | BC_Gen5_14 | BC_Gen5_16 | BC_Gen5_18 | BC_Gen5_20 |
---|---|---|---|---|---|
Hardware | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
vCores | 12 | 14 | 16 | 18 | 20 |
Memory (GB) | 62.3 | 72.7 | 83 | 93.4 | 103.8 |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | 11.02 | 13.39 | 15.77 | 18.14 | 20.51 |
Max data size (GB) | 3072 | 3072 | 3072 | 3072 | 3072 |
Max log size (GB) 1 | 922 | 922 | 922 | 922 | 922 |
Tempdb max data size (GB) | 384 | 448 | 512 | 576 | 640 |
Max local storage size (GB) | 4829 | 4829 | 4829 | 4829 | 4829 |
Storage type | Local SSD | Local SSD | Local SSD | Local SSD | Local SSD |
Read IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Write IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Max data IOPS 2 | 48,000 | 56,000 | 64,000 | 72,000 | 80,000 |
Max log rate (MBps) | 96 | 96 | 96 | 96 | 96 |
Max concurrent workers | 1200 | 1400 | 1600 | 1800 | 2000 |
Max concurrent logins | 1200 | 1400 | 1600 | 1800 | 2000 |
Max concurrent external connections 3 | 120 | 140 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 4 | 4 | 4 | 4 | 4 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes |
Read Scale-out | Yes | Yes | Yes | Yes | Yes |
Included backup storage | 1X DB size | 1X DB size | 1X DB size | 1X DB size | 1X DB size |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
Business critical Standard-series (Gen5) compute generation (part 3 of 3)
Compute size (service objective) | BC_Gen5_24 | BC_Gen5_32 | BC_Gen5_40 | BC_Gen5_80 | BC_Gen5_128 |
---|---|---|---|---|---|
Hardware | Gen5 | Gen5 | Gen5 | Gen5 | Gen5 |
vCores | 24 | 32 | 40 | 80 | 1284 |
Memory (GB) | 124.6 | 166.1 | 207.6 | 415.2 | 625 |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | 25.25 | 37.94 | 52.23 | 131.64 | 227.02 |
Max data size (GB) | 4096 | 4096 | 4096 | 4096 | 4096 |
Max log size (GB) 1 | 1024 | 1024 | 1024 | 1024 | 1024 |
Tempdb max data size (GB) | 768 | 1024 | 1280 | 2560 | 2560 |
Max local storage size (GB) | 4829 | 4829 | 4829 | 4829 | 4829 |
Storage type | Local SSD | Local SSD | Local SSD | Local SSD | Local SSD |
Read IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Write IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Max data IOPS 2 | 96,000 | 128,000 | 160,000 | 204,800 | 327,680 |
Max log rate (MBps) | 96 | 96 | 96 | 96 | 96 |
Max concurrent workers | 2400 | 3200 | 4000 | 8000 | 12,800 |
Max concurrent logins | 2400 | 3200 | 4000 | 8000 | 8000 |
Max concurrent external connections 3 | 150 | 150 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 4 | 4 | 4 | 4 | 4 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes |
Read Scale-out | Yes | Yes | Yes | Yes | Yes |
Included backup storage | 1X DB size | 1X DB size | 1X DB size | 1X DB size | 1X DB size |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
4 The 128 vCore offering is currently in preview.
Business Critical - provisioned compute - M-series
For important information about M-series hardware availability, see Azure offer types supported by M-series.
Business Critical M-series hardware (part 1 of 2)
Compute size (service objective) | BC_M_8 | BC_M_10 | BC_M_12 | BC_M_14 | BC_M_16 | BC_M_18 |
---|---|---|---|---|---|---|
Hardware | M-series | M-series | M-series | M-series | M-series | M-series |
vCores | 8 | 10 | 12 | 14 | 16 | 18 |
Memory (GB) | 235.4 | 294.3 | 353.2 | 412.0 | 470.9 | 529.7 |
Columnstore support | Yes | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | 64 | 80 | 96 | 112 | 128 | 150 |
Max data size (GB) | 512 | 640 | 768 | 896 | 1024 | 1152 |
Max log size (GB) 1 | 171 | 213 | 256 | 299 | 341 | 384 |
Tempdb max data size (GB) | 256 | 320 | 384 | 448 | 512 | 576 |
Max local storage size (GB) | 13,836 | 13,836 | 13,836 | 13,836 | 13,836 | 13,836 |
Storage type | Local SSD | Local SSD | Local SSD | Local SSD | Local SSD | Local SSD |
Read IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Write IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Max data IOPS 2 | 12,499 | 15,624 | 18,748 | 21,873 | 24,998 | 28,123 |
Max log rate (MBps) | 48 | 60 | 72 | 84 | 96 | 108 |
Max concurrent workers | 800 | 1,000 | 1,200 | 1,400 | 1,600 | 1,800 |
Max concurrent logins | 800 | 1,000 | 1,200 | 1,400 | 1,600 | 1,800 |
Max concurrent external connections 3 | 80 | 100 | 120 | 140 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 4 | 4 | 4 | 4 | 4 | 4 |
Multi-AZ | No | No | No | No | No | No |
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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
Business Critical M-series hardware (part 2 of 2)
Compute size (service objective) | BC_M_20 | BC_M_24 | BC_M_32 | BC_M_64 | BC_M_128 |
---|---|---|---|---|---|
Hardware | M-series | M-series | M-series | M-series | M-series |
vCores | 20 | 24 | 32 | 64 | 128 |
Memory (GB) | 588.6 | 706.3 | 941.8 | 1883.5 | 3767.0 |
Columnstore support | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | 172 | 216 | 304 | 704 | 1768 |
Max data size (GB) | 1280 | 1536 | 2048 | 4096 | 4096 |
Max log size (GB) 1 | 427 | 512 | 683 | 1024 | 1024 |
Tempdb max data size (GB) | 640 | 768 | 1024 | 2048 | 4096 |
Max local storage size (GB) | 13,836 | 13,836 | 13,836 | 13,836 | 13,836 |
Storage type | Local SSD | Local SSD | Local SSD | Local SSD | Local SSD |
Read IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Write IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Max data IOPS 2 | 31,248 | 37,497 | 49,996 | 99,993 | 160,000 |
Max log rate (MBps) | 120 | 144 | 192 | 264 | 264 |
Max concurrent workers | 2,000 | 2,400 | 3,200 | 6,400 | 12,800 |
Max concurrent logins | 2,000 | 2,400 | 3,200 | 6,400 | 12,800 |
Max concurrent external connections 3 | 150 | 150 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 4 | 4 | 4 | 4 | 4 |
Multi-AZ | No | No | No | No | No |
Read Scale-out | Yes | Yes | Yes | Yes | Yes |
Included backup storage | 1X DB size | 1X DB size | 1X DB size | 1X DB size | 1X DB size |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
Business Critical - provisioned compute - DC-series
Compute size (service objective) | BC_DC_2 | BC_DC_4 | BC_DC_6 | BC_DC_8 |
---|---|---|---|---|
Hardware | DC-series | DC-series | DC-series | DC-series |
vCores | 2 | 4 | 6 | 8 |
Memory (GB) | 9 | 18 | 27 | 36 |
Columnstore support | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | 1.7 | 3.7 | 5.9 | 8.2 |
Max data size (GB) | 768 | 768 | 768 | 768 |
Max log size (GB) 1 | 230 | 230 | 230 | 230 |
Tempdb max data size (GB) | 64 | 128 | 192 | 256 |
Max local storage size (GB) | 1406 | 1406 | 1406 | 1406 |
Storage type | Local SSD | Local SSD | Local SSD | Local SSD |
Read IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Write IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Max data IOPS 2 | 14,000 | 28,000 | 42,000 | 44,800 |
Max log rate (MBps) | 24 | 48 | 72 | 96 |
Max concurrent workers | 200 | 400 | 600 | 800 |
Max concurrent logins | 200 | 400 | 600 | 800 |
Max concurrent external connections 3 | 20 | 40 | 60 | 80 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 4 | 4 | 4 | 4 |
Multi-AZ | No | No | No | No |
Read Scale-out | No | No | No | No |
Included backup storage | 1X DB size | 1X DB size | 1X DB size | 1X DB size |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
Previously available hardware
This section includes details on previously available hardware.
Important
Gen4 hardware is being retired and is not available for new deployments, as announced on December 18, 2019. Customers using Gen4 hardware for Azure SQL Database, or Azure SQL Managed Instance should migrate to currently available hardware, such as standard-series (Gen5), before March 31, 2023. Existing Gen4 databases, elastic pools, and SQL managed instances will be migrated automatically to equivalent standard-series (Gen5) hardware.
Downtime caused by automatic migration will be minimal and similar to downtime during scaling operations within selected service tier. To avoid unplanned interruptions to workloads, migrate proactively at the time of your choice before March 31, 2023. For more information on Gen4 hardware retirement and migration to current hardware, see our blog post on Gen4 retirement.
Hyperscale - provisioned compute - Gen4
Hyperscale Gen4 hardware (part 1 of 2)
Compute size (service objective) | HS_Gen4_1 | HS_Gen4_2 | HS_Gen4_3 | HS_Gen4_4 | HS_Gen4_5 | HS_Gen4_6 |
---|---|---|---|---|---|---|
Hardware | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 |
vCores | 1 | 2 | 3 | 4 | 5 | 6 |
Memory (GB) | 7 | 14 | 21 | 28 | 35 | 42 |
RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
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 |
Max data size (TB) | 100 | 100 | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 32 | 64 | 96 | 128 | 160 | 192 |
Max local SSD IOPS 1 | 4000 | 8000 | 12,000 | 16,000 | 20,000 | 24,000 |
Max log rate (MBps) | 100 | 100 | 100 | 100 | 100 | 100 |
Local read IO latency2 | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Remote read IO latency2 | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms |
Write IO latency2 | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms |
Storage type | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 |
Max concurrent workers | 200 | 400 | 600 | 800 | 1000 | 1200 |
Max concurrent external connections 4 | 20 | 40 | 60 | 80 | 100 | 120 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | N/A | N/A | N/A | N/A | N/A | N/A |
Read Scale-out | Yes | Yes | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days | 7 days | 7 days |
1 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
2 Latency numbers are approximate and representative for typical workloads at steady state, but are not guaranteed.
3 Hyperscale is a multi-tiered architecture with separate compute and storage components. For more information, see Hyperscale service tier architecture.
Hyperscale Gen4 hardware (part 2 of 2)
Compute size (service objective) | HS_Gen4_7 | HS_Gen4_8 | HS_Gen4_9 | HS_Gen4_10 | HS_Gen4_16 | HS_Gen4_24 |
---|---|---|---|---|---|---|
Hardware | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 |
vCores | 7 | 8 | 9 | 10 | 16 | 24 |
Memory (GB) | 49 | 56 | 63 | 70 | 112 | 159.5 |
RBPEX Size | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory | 3X Memory |
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 |
Max data size (TB) | 100 | 100 | 100 | 100 | 100 | 100 |
Max log size (TB) | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
Tempdb max data size (GB) | 224 | 256 | 288 | 320 | 512 | 768 |
Max local SSD IOPS 1 | 28,000 | 32,000 | 36,000 | 40,000 | 64,000 | 76,800 |
Max log rate (MBps) | 100 | 100 | 100 | 100 | 100 | 100 |
Local read IO latency2 | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Remote read IO latency2 | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms | 1-5 ms |
Write IO latency2 | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms | 3-5 ms |
Storage type | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 | Multi-tiered3 |
Max concurrent workers | 1400 | 1600 | 1800 | 2000 | 3200 | 4800 |
Max concurrent external connections 4 | 140 | 150 | 150 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Secondary replicas | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 | 0-4 |
Multi-AZ | N/A | N/A | N/A | N/A | N/A | N/A |
Read Scale-out | Yes | Yes | Yes | Yes | Yes | Yes |
Backup storage retention | 7 days | 7 days | 7 days | 7 days | 7 days | 7 days |
1 Besides local SSD IO, workloads will use remote page server IO. Effective IOPS will depend on workload. For details, see Data IO Governance, and Data IO in resource utilization statistics.
2 Latency numbers are approximate and representative for typical workloads at steady state, but are not guaranteed.
3 Hyperscale is a multi-tiered architecture with separate compute and storage components. For more information, see Hyperscale service tier architecture.
4 See External Connections for additional details on what counts as an external connection.
General purpose - provisioned compute - Gen4
Important
New Gen4 databases are no longer supported in the Australia East or Brazil South regions.
General Purpose Gen4 hardware (part 1 of 2)
Compute size (service objective) | GP_Gen4_1 | GP_Gen4_2 | GP_Gen4_3 | GP_Gen4_4 | GP_Gen4_5 | GP_Gen4_6 |
---|---|---|---|---|---|---|
Hardware | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 |
vCores | 1 | 2 | 3 | 4 | 5 | 6 |
Memory (GB) | 7 | 14 | 21 | 28 | 35 | 42 |
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 |
Max data size (GB) | 1024 | 1024 | 1536 | 1536 | 1536 | 3072 |
Max log size (GB) 1 | 307 | 307 | 461 | 461 | 461 | 922 |
Tempdb max data size (GB) | 32 | 64 | 96 | 128 | 160 | 192 |
Storage type | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD |
Read IO latency (approximate) | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms |
Write IO latency (approximate) | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms |
Max data IOPS 2 | 320 | 640 | 960 | 1280 | 1600 | 1920 |
Max log rate (MBps) | 4.5 | 9 | 13.5 | 18 | 22.5 | 27 |
Max concurrent workers | 200 | 400 | 600 | 800 | 1000 | 1200 |
Max concurrent external connections 3 | 20 | 40 | 60 | 80 | 100 | 120 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
General Purpose Gen4 hardware (part 2 of 2)
Compute size (service objective) | GP_Gen4_7 | GP_Gen4_8 | GP_Gen4_9 | GP_Gen4_10 | GP_Gen4_16 | GP_Gen4_24 |
---|---|---|---|---|---|---|
Hardware | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 |
vCores | 7 | 8 | 9 | 10 | 16 | 24 |
Memory (GB) | 49 | 56 | 63 | 70 | 112 | 159.5 |
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 |
Max data size (GB) | 3072 | 3072 | 3072 | 3072 | 4096 | 4096 |
Max log size (GB) 1 | 922 | 922 | 922 | 922 | 1229 | 1229 |
Tempdb max data size (GB) | 224 | 256 | 288 | 320 | 512 | 768 |
Storage type | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD | Remote SSD |
Read IO latency (approximate) | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms | 5-10 ms |
Write IO latency (approximate) | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms | 5-7 ms |
Max data IOPS 2 | 2240 | 2560 | 2880 | 3200 | 5120 | 7680 |
Max log rate (MBps) | 31.5 | 36 | 40.5 | 45 | 50 | 50 |
Max concurrent workers | 1400 | 1600 | 1800 | 2000 | 3200 | 4800 |
Max concurrent external connections 3 | 140 | 150 | 150 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
Business critical - provisioned compute - Gen4
Important
New Gen4 databases are no longer supported in the Australia East or Brazil South regions.
Business critical Gen4 hardware (part 1 of 2)
Compute size (service objective) | BC_Gen4_1 | BC_Gen4_2 | BC_Gen4_3 | BC_Gen4_4 | BC_Gen4_5 | BC_Gen4_6 |
---|---|---|---|---|---|---|
Hardware | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 |
vCores | 1 | 2 | 3 | 4 | 5 | 6 |
Memory (GB) | 7 | 14 | 21 | 28 | 35 | 42 |
Columnstore support | Yes | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | 1 | 2 | 3 | 4 | 5 | 6 |
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) 1 | 307 | 307 | 307 | 307 | 307 | 307 |
Tempdb max data size (GB) | 32 | 64 | 96 | 128 | 160 | 192 |
Max local storage size (GB) | 1356 | 1356 | 1356 | 1356 | 1356 | 1356 |
Read IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Write IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Max data IOPS 2 | 4,000 | 8,000 | 12,000 | 16,000 | 20,000 | 24,000 |
Max log rate (MBps) | 8 | 16 | 24 | 32 | 40 | 48 |
Max concurrent workers | 200 | 400 | 600 | 800 | 1000 | 1200 |
Max concurrent logins | 200 | 400 | 600 | 800 | 1000 | 1200 |
Max concurrent external connections 3 | 20 | 40 | 60 | 80 | 100 | 120 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 4 | 4 | 4 | 4 | 4 | 4 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes | Yes |
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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
Business critical Gen4 hardware (part 2 of 2)
Compute size (service objective) | BC_Gen4_7 | BC_Gen4_8 | BC_Gen4_9 | BC_Gen4_10 | BC_Gen4_16 | BC_Gen4_24 |
---|---|---|---|---|---|---|
Hardware | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 | Gen4 |
vCores | 7 | 8 | 9 | 10 | 16 | 24 |
Memory (GB) | 49 | 56 | 63 | 70 | 112 | 159.5 |
Columnstore support | Yes | Yes | Yes | Yes | Yes | Yes |
In-memory OLTP storage (GB) | 7 | 8 | 9.5 | 11 | 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) 1 | 307 | 307 | 307 | 307 | 307 | 307 |
Tempdb max data size (GB) | 224 | 256 | 288 | 320 | 512 | 768 |
Max local storage size (GB) | 1356 | 1356 | 1356 | 1356 | 1356 | 1356 |
Read IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Write IO latency (approximate) | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms | 1-2 ms |
Max data IOPS 2 | 28,000 | 32,000 | 36,000 | 40,000 | 64,000 | 76,800 |
Max log rate (MBps) | 56 | 64 | 64 | 64 | 64 | 64 |
Max concurrent workers | 1400 | 1600 | 1800 | 2000 | 3200 | 4800 |
Max concurrent logins | 1400 | 1600 | 1800 | 2000 | 3200 | 4800 |
Max concurrent external connections 3 | 140 | 150 | 150 | 150 | 150 | 150 |
Max concurrent sessions | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 |
Number of replicas | 4 | 4 | 4 | 4 | 4 | 4 |
Multi-AZ | Yes | Yes | Yes | Yes | Yes | Yes |
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 |
1 For documented max data size values. Reducing max data size reduces max log size proportionally.
2 The maximum value for IO sizes ranging between 8 KB and 64 KB. Actual IOPS are workload-dependent. For details, see Data IO Governance.
3 See External Connections for additional details on what counts as an external connection.
Next steps
- For DTU resource limits for a single database, see resource limits for single databases using the DTU purchasing model
- For vCore resource limits for elastic pools, see resource limits for elastic pools using the vCore purchasing model
- For DTU resource limits for elastic pools, see resource limits for elastic pools using the DTU purchasing model
- For resource limits for SQL Managed Instance, see SQL Managed Instance resource limits.
- For information about general Azure limits, see Azure subscription and service limits, quotas, and constraints.
- For information about resource limits on a server, see overview of resource limits on a server for information about limits at the server and subscription levels.
- ALTER DATABASE - Azure SQL Database
- CREATE DATABASE - Azure SQL Database
Feedback
Submit and view feedback for