使用 vCore 购买模型的单一数据库的资源限制Resource limits for single databases using the vCore purchasing model
Azure SQL 数据库
本文提供针对使用 vCore 购买模型的 Azure SQL 数据库中单一数据库的详细资源限制。This article provides the detailed resource limits for single databases in Azure SQL Database using the vCore purchasing model.
有关服务器上单一数据库的 DTU 购买模型限制,请参阅服务器上的资源限制概述。For DTU purchasing model limits for single databases on a server, see Overview of resource limits on a server.
可通过 Azure 门户、Transact-SQL、PowerShell、Azure CLI 或 REST API 为单一数据库设置服务层级、计算大小(服务目标)和存储量。You can set the service tier, compute size (service objective), and storage amount for a single database using the Azure portal, Transact-SQL, PowerShell, the Azure CLI, or the REST API.
重要
有关缩放指南和注意事项,请参阅缩放单一数据库。For scaling guidance and considerations, see Scale a single database.
常规用途 - 无服务器计算 - Gen5General purpose - serverless compute - Gen5
无服务器计算层目前仅在 Gen5 硬件上提供。The serverless compute tier is currently available on Gen5 hardware only.
第 5 代计算(第 1 部分)Gen5 compute generation (part 1)
计算大小(服务目标)Compute size (service objective) | GP_S_Gen5_1GP_S_Gen5_1 | GP_S_Gen5_2GP_S_Gen5_2 | GP_S_Gen5_4GP_S_Gen5_4 | GP_S_Gen5_6GP_S_Gen5_6 | GP_S_Gen5_8GP_S_Gen5_8 |
---|---|---|---|---|---|
计算的代Compute generation | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 |
最小-最大 vCore 数Min-max vCores | 0.5-10.5-1 | 0.5-20.5-2 | 0.5-40.5-4 | 0.75-60.75-6 | 1.0-81.0-8 |
最小-最大内存 (GB)Min-max memory (GB) | 2.02-32.02-3 | 2.05-62.05-6 | 2.10-122.10-12 | 2.25-182.25-18 | 3.00-243.00-24 |
最小-最大自动暂停延迟(分钟)Min-max auto-pause delay (minutes) | 60-1008060-10080 | 60-1008060-10080 | 60-1008060-10080 | 60-1008060-10080 | 60-1008060-10080 |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 空值N/A | 空值N/A | 空值N/A | 空值N/A | 空值N/A |
最大数据大小 (GB)Max data size (GB) | 512512 | 10241024 | 10241024 | 10241024 | 15361536 |
最大日志大小 (GB)Max log size (GB) | 154154 | 307307 | 307307 | 307307 | 461461 |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 3232 | 6464 | 128128 | 192192 | 256256 |
存储类型Storage type | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD |
IO 延迟(近似)IO latency (approximate) | 5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
最大数据 IOPS *Max data IOPS * | 320320 | 640640 | 12801280 | 19201920 | 25602560 |
最大日志速率 (MBps)Max log rate (MBps) | 4.54.5 | 99 | 1818 | 2727 | 3636 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 7575 | 150150 | 300300 | 450450 | 600600 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
副本数Number of replicas | 11 | 11 | 11 | 11 | 11 |
读取横向扩展Read Scale-out | 空值N/A | 空值N/A | 空值N/A | 空值N/A | 空值N/A |
随附的备份存储Included backup storage | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size |
* IO 大小的最大值,范围为 8 KB 到 64 KB。* The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.
第 5 代计算(第 2 部分)Gen5 compute generation (part 2)
计算大小(服务目标)Compute size (service objective) | GP_S_Gen5_10GP_S_Gen5_10 | GP_S_Gen5_12GP_S_Gen5_12 | GP_S_Gen5_14GP_S_Gen5_14 | GP_S_Gen5_16GP_S_Gen5_16 |
---|---|---|---|---|
计算的代Compute generation | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 |
最小-最大 vCore 数Min-max vCores | 1.25-101.25-10 | 1.50-121.50-12 | 1.75-141.75-14 | 2.00-162.00-16 |
最小-最大内存 (GB)Min-max memory (GB) | 3.75-303.75-30 | 4.50-364.50-36 | 5.25-425.25-42 | 6.00-486.00-48 |
最小-最大自动暂停延迟(分钟)Min-max auto-pause delay (minutes) | 60-1008060-10080 | 60-1008060-10080 | 60-1008060-10080 | 60-1008060-10080 |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
最大数据大小 (GB)Max data size (GB) | 15361536 | 30723072 | 30723072 | 30723072 |
最大日志大小 (GB)Max log size (GB) | 461461 | 461461 | 461461 | 922922 |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 320320 | 384384 | 448448 | 512512 |
存储类型Storage type | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD |
IO 延迟(近似)IO latency (approximate) | 5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
最大数据 IOPS *Max data IOPS * | 32003200 | 38403840 | 44804480 | 51205120 |
最大日志速率 (MBps)Max log rate (MBps) | 3636 | 3636 | 3636 | 3636 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 750750 | 900900 | 10501050 | 12001200 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
副本数Number of replicas | 11 | 11 | 11 | 11 |
读取横向扩展Read Scale-out | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
随附的备份存储Included backup storage | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size |
* IO 大小的最大值,范围为 8 KB 到 64 KB。* The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.
第 5 代计算(第 3 部分)Gen5 compute generation (part 3)
计算大小(服务目标)Compute size (service objective) | GP_S_Gen5_18GP_S_Gen5_18 | GP_S_Gen5_20GP_S_Gen5_20 | GP_S_Gen5_24GP_S_Gen5_24 | GP_S_Gen5_32GP_S_Gen5_32 | GP_S_Gen5_40GP_S_Gen5_40 |
---|---|---|---|---|---|
计算的代Compute generation | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 |
最小-最大 vCore 数Min-max vCores | 2.25-182.25-18 | 2.5-202.5-20 | 3-243-24 | 4-324-32 | 5-405-40 |
最小-最大内存 (GB)Min-max memory (GB) | 6.75-546.75-54 | 7.5-607.5-60 | 9-729-72 | 12-9612-96 | 15-12015-120 |
最小-最大自动暂停延迟(分钟)Min-max auto-pause delay (minutes) | 60-1008060-10080 | 60-1008060-10080 | 60-1008060-10080 | 60-1008060-10080 | 60-1008060-10080 |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
最大数据大小 (GB)Max data size (GB) | 30723072 | 30723072 | 40964096 | 40964096 | 40964096 |
最大日志大小 (GB)Max log size (GB) | 922922 | 922922 | 10241024 | 10241024 | 10241024 |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 576576 | 640640 | 768768 | 10241024 | 12801280 |
存储类型Storage type | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD |
IO 延迟(近似)IO latency (approximate) | 5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
最大数据 IOPS *Max data IOPS * | 57605760 | 64006400 | 76807680 | 1024010240 | 1280012800 |
最大日志速率 (MBps)Max log rate (MBps) | 3636 | 3636 | 3636 | 3636 | 3636 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 13501350 | 15001500 | 18001800 | 24002400 | 30003000 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
副本数Number of replicas | 11 | 11 | 11 | 11 | 11 |
读取横向扩展Read Scale-out | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
随附的备份存储Included backup storage | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size |
* IO 大小的最大值,范围为 8 KB 到 64 KB。* The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.
超大规模 - 预配的计算 - Gen4Hyperscale - provisioned compute - Gen4
第 4 代计算(第 1 部分)Gen4 compute generation (part 1)
计算大小(服务目标)Compute size (service objective) | HS_Gen4_1HS_Gen4_1 | HS_Gen4_2HS_Gen4_2 | HS_Gen4_3HS_Gen4_3 | HS_Gen4_4HS_Gen4_4 | HS_Gen4_5HS_Gen4_5 | HS_Gen4_6HS_Gen4_6 |
---|---|---|---|---|---|---|
计算的代Compute generation | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 |
vCore 数vCores | 11 | 22 | 33 | 44 | 55 | 66 |
内存 (GB)Memory (GB) | 77 | 1414 | 2121 | 2828 | 3535 | 4242 |
RBPEX 大小RBPEX Size | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
最大数据大小 (TB)Max data size (TB) | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 |
最大日志大小 (TB)Max log size (TB) | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 3232 | 6464 | 9696 | 128128 | 160160 | 192192 |
存储类型Storage type | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 |
最大本地 SSD IOPS *Max local SSD IOPS * | 40004000 | 80008000 | 1200012000 | 1600016000 | 2000020000 | 2400024000 |
最大日志速率 (MBps)Max log rate (MBps) | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 |
IO 延迟(近似)IO latency (approximate) | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 200200 | 400400 | 600600 | 800800 | 10001000 | 12001200 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
次要副本Secondary replicas | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 |
读取横向扩展Read Scale-out | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
备份存储保留期Backup storage retention | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days |
* 除了本地 SSD IO 以外,工作负荷还使用远程页服务器 IO。* Besides local SSD IO, workloads will use remote page server IO.
第 4 代计算(第 2 部分)Gen4 compute generation (part 2)
计算大小(服务目标)Compute size (service objective) | HS_Gen4_7HS_Gen4_7 | HS_Gen4_8HS_Gen4_8 | HS_Gen4_9HS_Gen4_9 | HS_Gen4_10HS_Gen4_10 | HS_Gen4_16HS_Gen4_16 | HS_Gen4_24HS_Gen4_24 |
---|---|---|---|---|---|---|
计算的代Compute generation | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 |
vCore 数vCores | 77 | 88 | 99 | 1010 | 1616 | 2424 |
内存 (GB)Memory (GB) | 4949 | 5656 | 6363 | 7070 | 112112 | 159.5159.5 |
RBPEX 大小RBPEX Size | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
最大数据大小 (TB)Max data size (TB) | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 |
最大日志大小 (TB)Max log size (TB) | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 224224 | 256256 | 288288 | 320320 | 512512 | 768768 |
存储类型Storage type | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 |
最大本地 SSD IOPS *Max local SSD IOPS * | 2800028000 | 3200032000 | 3600036000 | 4000040000 | 6400064000 | 7680076800 |
最大日志速率 (MBps)Max log rate (MBps) | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 |
IO 延迟(近似)IO latency (approximate) | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 14001400 | 16001600 | 18001800 | 20002000 | 32003200 | 48004800 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
次要副本Secondary replicas | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 |
读取横向扩展Read Scale-out | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
备份存储保留期Backup storage retention | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days |
* 除了本地 SSD IO 以外,工作负荷还使用远程页服务器 IO。* Besides local SSD IO, workloads will use remote page server IO. 有效 IOPS 取决于工作负荷。Effective IOPS will depend on workload.
超大规模 - 预配的计算 - Gen5Hyperscale - provisioned compute - Gen5
第 5 代计算(第 1 部分)Gen5 compute generation (part 1)
计算大小(服务目标)Compute size (service objective) | HS_Gen5_2HS_Gen5_2 | HS_Gen5_4HS_Gen5_4 | HS_Gen5_6HS_Gen5_6 | HS_Gen_8HS_Gen_8 | HS_Gen5_10HS_Gen5_10 | HS_Gen5_12HS_Gen5_12 | HS_Gen5_14HS_Gen5_14 |
---|---|---|---|---|---|---|---|
计算的代Compute generation | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 |
vCore 数vCores | 22 | 44 | 66 | 88 | 1010 | 1212 | 1414 |
内存 (GB)Memory (GB) | 10.410.4 | 20.820.8 | 31.131.1 | 41.541.5 | 51.951.9 | 62.362.3 | 72.772.7 |
RBPEX 大小RBPEX Size | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
最大数据大小 (TB)Max data size (TB) | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 |
最大日志大小 (TB)Max log size (TB) | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 6464 | 128128 | 192192 | 256256 | 320320 | 384384 | 448448 |
存储类型Storage type | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 |
最大本地 SSD IOPS *Max local SSD IOPS * | 80008000 | 1600016000 | 2400024000 | 3200032000 | 4000040000 | 4800048000 | 5600056000 |
最大日志速率 (MBps)Max log rate (MBps) | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 |
IO 延迟(近似)IO latency (approximate) | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 200200 | 400400 | 600600 | 800800 | 10001000 | 12001200 | 14001400 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
次要副本Secondary replicas | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 |
读取横向扩展Read Scale-out | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
备份存储保留期Backup storage retention | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days |
* 除了本地 SSD IO 以外,工作负荷还使用远程页服务器 IO。* Besides local SSD IO, workloads will use remote page server IO. 有效 IOPS 取决于工作负荷。Effective IOPS will depend on workload.
第 5 代计算(第 2 部分)Gen5 compute generation (part 2)
计算大小(服务目标)Compute size (service objective) | HS_Gen5_16HS_Gen5_16 | HS_Gen5_18HS_Gen5_18 | HS_Gen5_20HS_Gen5_20 | HS_Gen_24HS_Gen_24 | HS_Gen5_32HS_Gen5_32 | HS_Gen5_40HS_Gen5_40 | HS_Gen5_80HS_Gen5_80 |
---|---|---|---|---|---|---|---|
计算的代Compute generation | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 |
vCore 数vCores | 1616 | 1818 | 2020 | 2424 | 3232 | 4040 | 8080 |
内存 (GB)Memory (GB) | 8383 | 93.493.4 | 103.8103.8 | 124.6124.6 | 166.1166.1 | 207.6207.6 | 415.2415.2 |
RBPEX 大小RBPEX Size | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory | 3 倍内存3X Memory |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
最大数据大小 (TB)Max data size (TB) | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 |
最大日志大小 (TB)Max log size (TB) | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited | 无限制Unlimited |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 512512 | 576576 | 640640 | 768768 | 10241024 | 12801280 | 25602560 |
存储类型Storage type | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 | 注释 1Note 1 |
最大本地 SSD IOPS *Max local SSD IOPS * | 6400064000 | 7200072000 | 8000080000 | 9600096000 | 160000160000 | 192000192000 | 204800204800 |
最大日志速率 (MBps)Max log rate (MBps) | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 | 100100 |
IO 延迟(近似)IO latency (approximate) | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 | 注释 2Note 2 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 16001600 | 18001800 | 20002000 | 24002400 | 32003200 | 40004000 | 80008000 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
次要副本Secondary replicas | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 | 0-40-4 |
读取横向扩展Read Scale-out | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
备份存储保留期Backup storage retention | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days | 7 天7 days |
* 除了本地 SSD IO 以外,工作负荷还使用远程页服务器 IO。* Besides local SSD IO, workloads will use remote page server IO. 有效 IOPS 取决于工作负荷。Effective IOPS will depend on workload.
注释Notes
注释 1:超大规模是具有单独计算和存储组件的多层体系结构:“超大规模”服务层级体系结构Note 1: Hyperscale is a multi-tiered architecture with separate compute and storage components: Hyperscale Service Tier Architecture
注释 2:对于本地计算副本 SSD 上的数据,延迟为 1-2 ms,这缓存最常用的数据页。Note 2: 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.
常规用途 - 预配的计算 - Gen4General purpose - provisioned compute - Gen4
第 4 代计算(第 1 部分)Gen4 compute generation (part 1)
计算大小(服务目标)Compute size (service objective) | GP_Gen4_1GP_Gen4_1 | GP_Gen4_2GP_Gen4_2 | GP_Gen4_3GP_Gen4_3 | GP_Gen4_4GP_Gen4_4 | GP_Gen4_5GP_Gen4_5 | GP_Gen4_6GP_Gen4_6 |
---|---|---|---|---|---|---|
计算的代Compute generation | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 |
vCore 数vCores | 11 | 22 | 33 | 44 | 55 | 66 |
内存 (GB)Memory (GB) | 77 | 1414 | 2121 | 2828 | 3535 | 4242 |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
最大数据大小 (GB)Max data size (GB) | 10241024 | 10241024 | 15361536 | 15361536 | 15361536 | 30723072 |
最大日志大小 (GB)Max log size (GB) | 307307 | 307307 | 461461 | 461461 | 461461 | 922922 |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 3232 | 6464 | 9696 | 128128 | 160160 | 192192 |
存储类型Storage type | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD |
IO 延迟(近似)IO latency (approximate) | 5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
最大数据 IOPS *Max data IOPS * | 320320 | 640640 | 960960 | 12801280 | 16001600 | 19201920 |
最大日志速率 (MBps)Max log rate (MBps) | 4.54.5 | 99 | 13.513.5 | 1818 | 22.522.5 | 2727 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 200200 | 400400 | 600600 | 800800 | 10001000 | 12001200 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
副本数Number of replicas | 11 | 11 | 11 | 11 | 11 | 11 |
读取横向扩展Read Scale-out | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
随附的备份存储Included backup storage | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size |
* IO 大小的最大值,范围为 8 KB 到 64 KB。* The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.
第 4 代计算(第 2 部分)Gen4 compute generation (part 2)
计算大小(服务目标)Compute size (service objective) | GP_Gen4_7GP_Gen4_7 | GP_Gen4_8GP_Gen4_8 | GP_Gen4_9GP_Gen4_9 | GP_Gen4_10GP_Gen4_10 | GP_Gen4_16GP_Gen4_16 | GP_Gen4_24GP_Gen4_24 |
---|---|---|---|---|---|---|
计算的代Compute generation | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 |
vCore 数vCores | 77 | 88 | 99 | 1010 | 1616 | 2424 |
内存 (GB)Memory (GB) | 4949 | 5656 | 6363 | 7070 | 112112 | 159.5159.5 |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 空值N/A | 不适用N/A | 空值N/A | 空值N/A | 空值N/A | 空值N/A |
最大数据大小 (GB)Max data size (GB) | 30723072 | 30723072 | 30723072 | 30723072 | 40964096 | 40964096 |
最大日志大小 (GB)Max log size (GB) | 922922 | 922922 | 922922 | 922922 | 12291229 | 12291229 |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 224224 | 256256 | 288288 | 320320 | 512512 | 768768 |
存储类型Storage type | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD |
IO 延迟(近似)IO latency (approximate) | 5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
最大数据 IOPS *Max data IOPS * | 22402240 | 25602560 | 28802880 | 32003200 | 51205120 | 76807680 |
最大日志速率 (MBps)Max log rate (MBps) | 31.531.5 | 3636 | 3636 | 3636 | 3636 | 3636 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 14001400 | 16001600 | 18001800 | 20002000 | 32003200 | 48004800 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
副本数Number of replicas | 11 | 11 | 11 | 11 | 11 | 11 |
读取横向扩展Read Scale-out | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
随附的备份存储Included backup storage | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size |
* IO 大小的最大值,范围为 8 KB 到 64 KB。* The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.
常规用途 - 预配的计算 - Gen5General purpose - provisioned compute - Gen5
第 5 代计算(第 1 部分)Gen5 compute generation (part 1)
计算大小(服务目标)Compute size (service objective) | GP_Gen5_2GP_Gen5_2 | GP_Gen5_4GP_Gen5_4 | GP_Gen5_6GP_Gen5_6 | GP_Gen5_8GP_Gen5_8 | GP_Gen5_10GP_Gen5_10 | GP_Gen5_12GP_Gen5_12 | GP_Gen5_14GP_Gen5_14 |
---|---|---|---|---|---|---|---|
计算的代Compute generation | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 |
vCore 数vCores | 22 | 44 | 66 | 88 | 1010 | 1212 | 1414 |
内存 (GB)Memory (GB) | 10.410.4 | 20.820.8 | 31.131.1 | 41.541.5 | 51.951.9 | 62.362.3 | 72.772.7 |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 空值N/A | 空值N/A | 不适用N/A | 空值N/A | 空值N/A | 空值N/A | 空值N/A |
最大数据大小 (GB)Max data size (GB) | 10241024 | 10241024 | 15361536 | 15361536 | 15361536 | 30723072 | 30723072 |
最大日志大小 (GB)Max log size (GB) | 307307 | 307307 | 461461 | 461461 | 461461 | 922922 | 922922 |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 6464 | 128128 | 192192 | 256256 | 320320 | 384384 | 384384 |
存储类型Storage type | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD |
IO 延迟(近似)IO latency (approximate) | 5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
最大数据 IOPS *Max data IOPS * | 640640 | 12801280 | 19201920 | 25602560 | 32003200 | 38403840 | 44804480 |
最大日志速率 (MBps)Max log rate (MBps) | 99 | 1818 | 2727 | 3636 | 3636 | 3636 | 3636 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 200200 | 400400 | 600600 | 800800 | 10001000 | 12001200 | 14001400 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
副本数Number of replicas | 11 | 11 | 11 | 11 | 11 | 11 | 11 |
读取横向扩展Read Scale-out | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
随附的备份存储Included backup storage | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size |
* IO 大小的最大值,范围为 8 KB 到 64 KB。* The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.
第 5 代计算(第 2 部分)Gen5 compute generation (part 2)
计算大小(服务目标)Compute size (service objective) | GP_Gen5_16GP_Gen5_16 | GP_Gen5_18GP_Gen5_18 | GP_Gen5_20GP_Gen5_20 | GP_Gen5_24GP_Gen5_24 | GP_Gen5_32GP_Gen5_32 | GP_Gen5_40GP_Gen5_40 | GP_Gen5_80GP_Gen5_80 |
---|---|---|---|---|---|---|---|
计算的代Compute generation | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 |
vCore 数vCores | 1616 | 1818 | 2020 | 2424 | 3232 | 4040 | 8080 |
内存 (GB)Memory (GB) | 8383 | 93.493.4 | 103.8103.8 | 124.6124.6 | 166.1166.1 | 207.6207.6 | 415.2415.2 |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 不适用N/A | 不适用N/A | 空值N/A | 空值N/A | 空值N/A | 空值N/A | 空值N/A |
最大数据大小 (GB)Max data size (GB) | 30723072 | 30723072 | 30723072 | 40964096 | 40964096 | 40964096 | 40964096 |
最大日志大小 (GB)Max log size (GB) | 922922 | 922922 | 922922 | 10241024 | 10241024 | 10241024 | 10241024 |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 512512 | 576576 | 640640 | 768768 | 10241024 | 12801280 | 25602560 |
存储类型Storage type | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD | 远程 SSDRemote SSD |
IO 延迟(近似)IO latency (approximate) | 5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
5-7 毫秒(写入)5-7 ms (write) 5-10 毫秒(读取)5-10 ms (read) |
最大数据 IOPS *Max data IOPS * | 51205120 | 57605760 | 64006400 | 76807680 | 1024010240 | 1280012800 | 1280012800 |
最大日志速率 (MBps)Max log rate (MBps) | 3636 | 3636 | 3636 | 3636 | 3636 | 3636 | 3636 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 16001600 | 18001800 | 20002000 | 24002400 | 32003200 | 40004000 | 80008000 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
副本数Number of replicas | 11 | 11 | 11 | 11 | 11 | 11 | 11 |
读取横向扩展Read Scale-out | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A | 不适用N/A |
随附的备份存储Included backup storage | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size |
* IO 大小的最大值,范围为 8 KB 到 64 KB。* The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.
业务关键 - 预配的计算 - Gen4Business critical - provisioned compute - Gen4
第 4 代计算(第 1 部分)Gen4 compute generation (part 1)
计算大小(服务目标)Compute size (service objective) | BC_Gen4_1BC_Gen4_1 | BC_Gen4_2BC_Gen4_2 | BC_Gen4_3BC_Gen4_3 | BC_Gen4_4BC_Gen4_4 | BC_Gen4_5BC_Gen4_5 | BC_Gen4_6BC_Gen4_6 |
---|---|---|---|---|---|---|
计算的代Compute generation | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 |
vCore 数vCores | 11 | 22 | 33 | 44 | 55 | 66 |
内存 (GB)Memory (GB) | 77 | 1414 | 2121 | 2828 | 3535 | 4242 |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 11 | 22 | 33 | 44 | 55 | 66 |
存储类型Storage type | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD |
最大数据大小 (GB)Max data size (GB) | 10241024 | 10241024 | 10241024 | 10241024 | 10241024 | 10241024 |
最大日志大小 (GB)Max log size (GB) | 307307 | 307307 | 307307 | 307307 | 307307 | 307307 |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 3232 | 6464 | 9696 | 128128 | 160160 | 192192 |
IO 延迟(近似)IO latency (approximate) | 1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
最大数据 IOPS *Max data IOPS * | 4,0004,000 | 8,0008,000 | 12,00012,000 | 16,00016,000 | 20,00020,000 | 24,00024,000 |
最大日志速率 (MBps)Max log rate (MBps) | 88 | 1616 | 2424 | 3232 | 4040 | 4848 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 200200 | 400400 | 600600 | 800800 | 10001000 | 12001200 |
最大并发登录数Max concurrent logins | 200200 | 400400 | 600600 | 800800 | 10001000 | 12001200 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
副本数Number of replicas | 44 | 44 | 44 | 44 | 44 | 44 |
读取横向扩展Read Scale-out | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
随附的备份存储Included backup storage | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size |
* IO 大小的最大值,范围为 8 KB 到 64 KB。* The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.
第 4 代计算(第 2 部分)Gen4 compute generation (part 2)
计算大小(服务目标)Compute size (service objective) | BC_Gen4_7BC_Gen4_7 | BC_Gen4_8BC_Gen4_8 | BC_Gen4_9BC_Gen4_9 | BC_Gen4_10BC_Gen4_10 | BC_Gen4_16BC_Gen4_16 | BC_Gen4_24BC_Gen4_24 |
---|---|---|---|---|---|---|
计算的代Compute generation | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 | Gen4Gen4 |
vCore 数vCores | 77 | 88 | 99 | 1010 | 1616 | 2424 |
内存 (GB)Memory (GB) | 4949 | 5656 | 6363 | 7070 | 112112 | 159.5159.5 |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 77 | 88 | 9.59.5 | 1111 | 2020 | 3636 |
存储类型Storage type | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD |
最大数据大小 (GB)Max data size (GB) | 10241024 | 10241024 | 10241024 | 10241024 | 10241024 | 10241024 |
最大日志大小 (GB)Max log size (GB) | 307307 | 307307 | 307307 | 307307 | 307307 | 307307 |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 224224 | 256256 | 288288 | 320320 | 512512 | 768768 |
IO 延迟(近似)IO latency (approximate) | 1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
最大数据 IOPSMax data IOPS | 28,00028,000 | 32,00032,000 | 36,00036,000 | 40,00040,000 | 64,00064,000 | 76,80076,800 |
最大日志速率 (MBps)Max log rate (MBps) | 5656 | 6464 | 6464 | 6464 | 6464 | 6464 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 14001400 | 16001600 | 18001800 | 20002000 | 32003200 | 48004800 |
最大并发登录数(请求数)Max concurrent logins (requests) | 14001400 | 16001600 | 18001800 | 20002000 | 32003200 | 48004800 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
副本数Number of replicas | 44 | 44 | 44 | 44 | 44 | 44 |
读取横向扩展Read Scale-out | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
随附的备份存储Included backup storage | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size |
* IO 大小的最大值,范围为 8 KB 到 64 KB。* The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.
业务关键 - 预配的计算 - Gen5Business critical - provisioned compute - Gen5
第 5 代计算(第 1 部分)Gen5 compute generation (part 1)
计算大小(服务目标)Compute size (service objective) | BC_Gen5_2BC_Gen5_2 | BC_Gen5_4BC_Gen5_4 | BC_Gen5_6BC_Gen5_6 | BC_Gen5_8BC_Gen5_8 | BC_Gen5_10BC_Gen5_10 | BC_Gen5_12BC_Gen5_12 | BC_Gen5_14BC_Gen5_14 |
---|---|---|---|---|---|---|---|
计算的代Compute generation | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 |
vCore 数vCores | 22 | 44 | 66 | 88 | 1010 | 1212 | 1414 |
内存 (GB)Memory (GB) | 10.410.4 | 20.820.8 | 31.131.1 | 41.541.5 | 51.951.9 | 62.362.3 | 72.772.7 |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 1.571.57 | 3.143.14 | 4.714.71 | 6.286.28 | 8.658.65 | 11.0211.02 | 13.3913.39 |
最大数据大小 (GB)Max data size (GB) | 10241024 | 10241024 | 15361536 | 15361536 | 15361536 | 30723072 | 30723072 |
最大日志大小 (GB)Max log size (GB) | 307307 | 307307 | 461461 | 461461 | 461461 | 922922 | 922922 |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 6464 | 128128 | 192192 | 256256 | 320320 | 384384 | 448448 |
存储类型Storage type | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD |
IO 延迟(近似)IO latency (approximate) | 1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
最大数据 IOPS *Max data IOPS * | 80008000 | 16,00016,000 | 24,00024,000 | 32,00032,000 | 40,00040,000 | 48,00048,000 | 56,00056,000 |
最大日志速率 (MBps)Max log rate (MBps) | 2424 | 4848 | 7272 | 9696 | 9696 | 9696 | 9696 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 200200 | 400400 | 600600 | 800800 | 10001000 | 12001200 | 14001400 |
最大并发登录数Max concurrent logins | 200200 | 400400 | 600600 | 800800 | 10001000 | 12001200 | 14001400 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
副本数Number of replicas | 44 | 44 | 44 | 44 | 44 | 44 | 44 |
读取横向扩展Read Scale-out | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
随附的备份存储Included backup storage | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size |
* IO 大小的最大值,范围为 8 KB 到 64 KB。* The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.
第 5 代计算(第 2 部分)Gen5 compute generation (part 2)
计算大小(服务目标)Compute size (service objective) | BC_Gen5_16BC_Gen5_16 | BC_Gen5_18BC_Gen5_18 | BC_Gen5_20BC_Gen5_20 | BC_Gen5_24BC_Gen5_24 | BC_Gen5_32BC_Gen5_32 | BC_Gen5_40BC_Gen5_40 | BC_Gen5_80BC_Gen5_80 |
---|---|---|---|---|---|---|---|
计算的代Compute generation | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 | Gen5Gen5 |
vCore 数vCores | 1616 | 1818 | 2020 | 2424 | 3232 | 4040 | 8080 |
内存 (GB)Memory (GB) | 8383 | 93.493.4 | 103.8103.8 | 124.6124.6 | 166.1166.1 | 207.6207.6 | 415.2415.2 |
列存储支持Columnstore support | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) | 15.7715.77 | 18.1418.14 | 20.5120.51 | 25.2525.25 | 37.9437.94 | 52.2352.23 | 131.64131.64 |
最大数据大小 (GB)Max data size (GB) | 30723072 | 30723072 | 30723072 | 40964096 | 40964096 | 40964096 | 40964096 |
最大日志大小 (GB)Max log size (GB) | 922922 | 922922 | 922922 | 10241024 | 10241024 | 10241024 | 10241024 |
TempDB 最大数据大小 (GB)TempDB max data size (GB) | 512512 | 576576 | 640640 | 768768 | 10241024 | 12801280 | 25602560 |
存储类型Storage type | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD | 本地 SSDLocal SSD |
IO 延迟(近似)IO latency (approximate) | 1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
1-2 毫秒(写入)1-2 ms (write) 1-2 毫秒(读取)1-2 ms (read) |
最大数据 IOPS *Max data IOPS * | 64,00064,000 | 72,00072,000 | 80,00080,000 | 96,00096,000 | 128,000128,000 | 160,000160,000 | 204,800204,800 |
最大日志速率 (MBps)Max log rate (MBps) | 9696 | 9696 | 9696 | 9696 | 9696 | 9696 | 9696 |
最大并发工作线程数(请求数)Max concurrent workers (requests) | 16001600 | 18001800 | 20002000 | 24002400 | 32003200 | 40004000 | 80008000 |
最大并发登录数Max concurrent logins | 16001600 | 18001800 | 20002000 | 24002400 | 32003200 | 40004000 | 80008000 |
最大并发会话数Max concurrent sessions | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 | 30,00030,000 |
副本数Number of replicas | 44 | 44 | 44 | 44 | 44 | 44 | 44 |
读取横向扩展Read Scale-out | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes | 是Yes |
随附的备份存储Included backup storage | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size | 1 倍数据库大小1X DB size |
* IO 大小的最大值,范围为 8 KB 到 64 KB。* The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.
重要
在某些情况下,可能需要收缩数据库来回收未使用的空间。Under some circumstances, you may need to shrink a database to reclaim unused space. 有关详细信息,请参阅管理 Azure SQL 数据库中的文件空间。For more information, see Manage file space in Azure SQL Database.
后续步骤Next steps
- 有关单一数据库的 DTU 资源限制,请参阅使用 DTU 购买模型的单一数据库的资源限制For DTU resource limits for a single database, see resource limits for single databases using the DTU purchasing model
- 有关弹性池的 vCore 资源限制,请参阅使用 vCore 购买模型的弹性池的资源限制For vCore resource limits for elastic pools, see resource limits for elastic pools using the vCore purchasing model
- 有关弹性池的 DTU 资源限制,请参阅使用 DTU 购买模型的弹性池的资源限制For DTU resource limits for elastic pools, see resource limits for elastic pools using the DTU purchasing model
- 有关 SQL 托管实例的资源限制,请参阅 SQL 托管实例资源限制。For resource limits for SQL Managed Instance, see SQL Managed Instance resource limits.
- 有关常规 Azure 限制的相关信息,请参阅 Azure 订阅和服务限制、配额和约束。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.