使用 vCore 购买模型的弹性池的资源限制Resource limits for elastic pools using the vCore purchasing model

本文提供针对使用 vCore 购买模型的 Azure SQL 数据库弹性池和共用数据库的详细资源限制。This article provides the detailed resource limits for Azure SQL Database elastic pools and pooled databases using the vCore purchasing model.

有关 DTU 购买模型限制,请参阅 SQL 数据库 DTU 资源限制 - 弹性池For DTU purchasing model limits, see SQL Database DTU resource limits - elastic pools.

Important

在某些情况下,可能需要收缩数据库来回收未使用的空间。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.

可通过 Azure 门户PowerShellAzure CLIREST API 设置服务层级、计算大小和存储量。You can set the service tier, compute size, and storage amount using the Azure portal, PowerShell, the Azure CLI, or the REST API.

Important

有关缩放指南和注意事项,请参阅缩放弹性池For scaling guidance and considerations, see Scale an elastic pool

常规用途 - 预配的计算 - Gen4General purpose - provisioned compute - Gen4

“常规用途”服务层级:第 4 代计算平台(第 1 部分)General purpose service tier: Generation 4 compute platform (part 1)

计算大小Compute size 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
每个池的最大数据库数Max number DBs per pool 100100 200200 500500 500500 500500 500500
列存储支持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) 512512 756756 15361536 15361536 15361536 20482048
最大日志大小Max log size 154154 227227 461461 461461 461461 614614
TempDB 最大数据大小 (GB)TempDB max data size (GB) 3232 6464 9696 128128 160160 192192
存储类型Storage type 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage
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 1Max data IOPS per pool 1 400400 800800 12001200 16001600 20002000 24002400
每个池的最大日志速率 (MBps)Max log rate per pool (MBps) 4.74.7 9.49.4 14.114.1 18.818.8 23.423.4 28.128.1
每个池的最大并发工作线程数(请求数)2Max concurrent workers per pool (requests) 2 210210 420420 630630 840840 10501050 12601260
每个池的最大并发登录数 2Max concurrent logins per pool 2 210210 420420 630630 840840 10501050 12601260
最大并发会话数Max concurrent sessions 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000
每个数据库的最小/最大弹性池 vCore 选项Min/max elastic pool vCore choices per database 0, 0.25, 0.5, 10, 0.25, 0.5, 1 0, 0.25, 0.5, 1, 20, 0.25, 0.5, 1, 2 0, 0.25, 0.5, 1...30, 0.25, 0.5, 1...3 0, 0.25, 0.5, 1...40, 0.25, 0.5, 1...4 0, 0.25, 0.5, 1...50, 0.25, 0.5, 1...5 0, 0.25, 0.5, 1...60, 0.25, 0.5, 1...6
副本数Number of replicas 11 11 11 11 11 11
Multi-AZMulti-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 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 IO 大小的最大值,范围为 8 KB 到 64 KB。1 The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.

2 如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制2 For the max concurrent workers (requests) for any individual database, see Single database resource limits. 例如,如果弹性池使用 Gen5 且每个数据库的最大 vCore 数设置为 2,则最大并发辅助角色数目值为 200。For example, if the elastic pool is using Gen5 and the max vCore per database is set at 2, then the max concurrent workers value is 200. 如果每个数据库的最大 vCore 数设置为 0.5,则最大并发辅助角色数目值为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is set to 0.5, then the max concurrent workers value is 50 since on Gen5 there are a max of 100 concurrent workers per vCore. 对于每个数据库的最大 vCore 设置小于 1 个 vCore 或更少的其他情况,最大并发辅助角色数会相应重新缩放。For other max vCore settings per database that are less 1 vCore or less, the number of max concurrent workers is similarly rescaled.

“常规用途”服务层级:第 4 代计算平台(第 2 部分)General purpose service tier: Generation 4 compute platform (part 2)

计算大小Compute size 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 10 个10 1616 2424
内存 (GB)Memory (GB) 4949 5656 6363 7070 112112 159.5159.5
每个池的最大数据库数Max number DBs per pool 500500 500500 500500 500500 500500 500500
列存储支持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) 20482048 20482048 20482048 20482048 35843584 40964096
最大日志大小 (GB)Max log size (GB) 614614 614614 614614 614614 10751075 12291229
TempDB 最大数据大小 (GB)TempDB max data size (GB) 224224 256256 288288 320320 512512 768768
存储类型Storage type 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage
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 1Max data IOPS per pool 1 28002800 32003200 36003600 40004000 64006400 96009600
每个池的最大日志速率 (MBps)Max log rate per pool (MBps) 32.832.8 37.537.5 37.537.5 37.537.5 37.537.5 37.537.5
每个池的最大并发工作线程数(请求数)2Max concurrent workers per pool (requests) 2 14701470 16801680 18901890 21002100 33603360 50405040
最大并发登录池(请求数)2Max concurrent logins pool (requests) 2 14701470 16801680 18901890 21002100 33603360 50405040
最大并发会话数Max concurrent sessions 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000
每个数据库的最小/最大弹性池 vCore 选项Min/max elastic pool vCore choices per database 0, 0.25, 0.5, 1...70, 0.25, 0.5, 1...7 0, 0.25, 0.5, 1...80, 0.25, 0.5, 1...8 0, 0.25, 0.5, 1...90, 0.25, 0.5, 1...9 0, 0.25, 0.5, 1...100, 0.25, 0.5, 1...10 0, 0.25, 0.5, 1...10, 160, 0.25, 0.5, 1...10, 16 0, 0.25, 0.5, 1...10, 16, 240, 0.25, 0.5, 1...10, 16, 24
副本数Number of replicas 11 11 11 11 11 11
Multi-AZMulti-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 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 IO 大小的最大值,范围为 8 KB 到 64 KB。1 The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent. 2 如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制2 For the max concurrent workers (requests) for any individual database, see Single database resource limits. 例如,如果弹性池使用 Gen5 且每个数据库的最大 vCore 数设置为 2,则最大并发辅助角色数目值为 200。For example, if the elastic pool is using Gen5 and the max vCore per database is set at 2, then the max concurrent workers value is 200. 如果每个数据库的最大 vCore 数设置为 0.5,则最大并发辅助角色数目值为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is set to 0.5, then the max concurrent workers value is 50 since on Gen5 there are a max of 100 concurrent workers per vCore. 对于每个数据库的最大 vCore 设置小于 1 个 vCore 或更少的其他情况,最大并发辅助角色数会相应重新缩放。For other max vCore settings per database that are less 1 vCore or less, the number of max concurrent workers is similarly rescaled.

常规用途 - 预配的计算 - Gen5General purpose - provisioned compute - Gen5

“常规用途”服务层级:第 5 代计算平台(第 1 部分)General purpose service tier: Generation 5 compute platform (part 1)

计算大小Compute size 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 10 个10 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
每个池的最大数据库数Max number DBs per pool 100100 200200 500500 500500 500500 500500 500500
列存储支持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) 512512 756756 15361536 15361536 15361536 20482048 20482048
最大日志大小 (GB)Max log size (GB) 154154 227227 461461 461461 461461 614614 614614
TempDB 最大数据大小 (GB)TempDB max data size (GB) 6464 128128 192192 256256 320320 384384 448448
存储类型Storage type 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage
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 1Max data IOPS per pool 1 800800 16001600 24002400 32003200 40004000 48004800 56005600
每个池的最大日志速率 (MBps)Max log rate per pool (MBps) 9.49.4 18.818.8 28.128.1 37.537.5 37.537.5 37.537.5 37.537.5
每个池的最大并发工作线程数(请求数)2Max concurrent workers per pool (requests) 2 210210 420420 630630 840840 10501050 12601260 14701470
每个池的最大并发登录数(请求数)2Max concurrent logins per pool (requests) 2 210210 420420 630630 840840 10501050 12601260 14701470
最大并发会话数Max concurrent sessions 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000
每个数据库的最小/最大弹性池 vCore 选项Min/max elastic pool vCore choices per database 0, 0.25, 0.5, 1, 20, 0.25, 0.5, 1, 2 0, 0.25, 0.5, 1...40, 0.25, 0.5, 1...4 0, 0.25, 0.5, 1...60, 0.25, 0.5, 1...6 0, 0.25, 0.5, 1...80, 0.25, 0.5, 1...8 0, 0.25, 0.5, 1...100, 0.25, 0.5, 1...10 0, 0.25, 0.5, 1...120, 0.25, 0.5, 1...12 0, 0.25, 0.5, 1...140, 0.25, 0.5, 1...14
副本数Number of replicas 11 11 11 11 11 11 11
Multi-AZMulti-AZ 不适用N/A 不适用N/A 空值N/A 空值N/A 不适用N/A 空值N/A 不适用N/A
读取横向扩展Read Scale-out 空值N/A 空值N/A 空值N/A 空值N/A 空值N/A 空值N/A 不适用N/A
随附的备份存储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

1 IO 大小的最大值,范围为 8 KB 到 64 KB。1 The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.

2 如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制2 For the max concurrent workers (requests) for any individual database, see Single database resource limits. 例如,如果弹性池使用 Gen5 且每个数据库的最大 vCore 数设置为 2,则最大并发辅助角色数目值为 200。For example, if the elastic pool is using Gen5 and the max vCore per database is set at 2, then the max concurrent workers value is 200. 如果每个数据库的最大 vCore 数设置为 0.5,则最大并发辅助角色数目值为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is set to 0.5, then the max concurrent workers value is 50 since on Gen5 there are a max of 100 concurrent workers per vCore. 对于每个数据库的最大 vCore 设置小于 1 个 vCore 或更少的其他情况,最大并发辅助角色数会相应重新缩放。For other max vCore settings per database that are less 1 vCore or less, the number of max concurrent workers is similarly rescaled.

“常规用途”服务层级:第 5 代计算平台(第 2 部分)General purpose service tier: Generation 5 compute platform (part 2)

计算大小Compute size 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 20 个20 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
每个池的最大数据库数Max number DBs per pool 500500 500500 500500 500500 500500 500500 500500
列存储支持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) 20482048 30723072 30723072 30723072 40964096 40964096 40964096
最大日志大小 (GB)Max log size (GB) 614614 922922 922922 922922 12291229 12291229 12291229
TempDB 最大数据大小 (GB)TempDB max data size (GB) 512512 576576 640640 768768 10241024 12801280 25602560
存储类型Storage type 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage 高级(远程)存储Premium (Remote) Storage
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 1Max data IOPS per pool 1 6,4006,400 7,2007,200 8,0008,000 9,6009,600 12,80012,800 16,00016,000 32,00032,000
每个池的最大日志速率 (MBps)Max log rate per pool (MBps) 37.537.5 37.537.5 37.537.5 37.537.5 37.537.5 37.537.5 37.537.5
每个池的最大并发工作线程数(请求数)2Max concurrent workers per pool (requests) 2 16801680 18901890 21002100 25202520 33603360 42004200 84008400
每个池的最大并发登录数(请求数)2Max concurrent logins per pool (requests) 2 16801680 18901890 21002100 25202520 33603360 42004200 84008400
最大并发会话数Max concurrent sessions 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000
每个数据库的最小/最大弹性池 vCore 选项Min/max elastic pool vCore choices per database 0, 0.25, 0.5, 1...160, 0.25, 0.5, 1...16 0, 0.25, 0.5, 1...180, 0.25, 0.5, 1...18 0, 0.25, 0.5, 1...200, 0.25, 0.5, 1...20 0, 0.25, 0.5, 1...20, 240, 0.25, 0.5, 1...20, 24 0, 0.25, 0.5, 1...20, 24, 320, 0.25, 0.5, 1...20, 24, 32 0, 0.25, 0.5, 1...16, 24, 32, 400, 0.25, 0.5, 1...16, 24, 32, 40 0, 0.25, 0.5, 1...16, 24, 32, 40, 800, 0.25, 0.5, 1...16, 24, 32, 40, 80
副本数Number of replicas 11 11 11 11 11 11 11
Multi-AZMulti-AZ 空值N/A 空值N/A 空值N/A 不适用N/A 空值N/A 空值N/A 不适用N/A
读取横向扩展Read Scale-out 空值N/A 不适用N/A 不适用N/A 不适用N/A 空值N/A 空值N/A 空值N/A
随附的备份存储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

1 IO 大小的最大值,范围为 8 KB 到 64 KB。1 The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.

2 如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制2 For the max concurrent workers (requests) for any individual database, see Single database resource limits. 例如,如果弹性池使用 Gen5 且每个数据库的最大 vCore 数设置为 2,则最大并发辅助角色数目值为 200。For example, if the elastic pool is using Gen5 and the max vCore per database is set at 2, then the max concurrent workers value is 200. 如果每个数据库的最大 vCore 数设置为 0.5,则最大并发辅助角色数目值为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is set to 0.5, then the max concurrent workers value is 50 since on Gen5 there are a max of 100 concurrent workers per vCore. 对于每个数据库的最大 vCore 设置小于 1 个 vCore 或更少的其他情况,最大并发辅助角色数会相应重新缩放。For other max vCore settings per database that are less 1 vCore or less, the number of max concurrent workers is similarly rescaled.

业务关键 - 预配的计算 - Gen4Business critical - provisioned compute - Gen4

“业务关键”服务层级:第 4 代计算平台(第 1 部分)Business critical service tier: Generation 4 compute platform (part 1)

计算大小Compute size 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
vCore 数vCores 22 33 44 55 66
内存 (GB)Memory (GB) 1414 2121 2828 3535 4242
每个池的最大数据库数Max number DBs per pool 5050 100100 100100 100100 100100
列存储支持Columnstore support Yes Yes Yes Yes Yes
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) 22 33 44 55 66
存储类型Storage type 本地 SSDLocal SSD 本地 SSDLocal SSD 本地 SSDLocal SSD 本地 SSDLocal SSD 本地 SSDLocal SSD
最大数据大小 (GB)Max data size (GB) 10241024 10241024 10241024 10241024 10241024
最大日志大小 (GB)Max log size (GB) 307307 307307 307307 307307 307307
TempDB 最大数据大小 (GB)TempDB max data size (GB) 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)
每个池的最大数据 IOPS 1Max data IOPS per pool 1 9,0009,000 13,50013,500 18,00018,000 22,50022,500 27,00027,000
每个池的最大日志速率 (MBps)Max log rate per pool (MBps) 20 个20 3030 4040 5050 6060
每个池的最大并发工作线程数(请求数)2Max concurrent workers per pool (requests) 2 420420 630630 840840 10501050 12601260
每个池的最大并发登录数(请求数)2Max concurrent logins per pool (requests) 2 420420 630630 840840 10501050 12601260
最大并发会话数Max concurrent sessions 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000
每个数据库的最小/最大弹性池 vCore 选项Min/max elastic pool vCore choices per database 0, 0.25, 0.5, 1, 20, 0.25, 0.5, 1, 2 0, 0.25, 0.5, 1...30, 0.25, 0.5, 1...3 0, 0.25, 0.5, 1...40, 0.25, 0.5, 1...4 0, 0.25, 0.5, 1...50, 0.25, 0.5, 1...5 0, 0.25, 0.5, 1...60, 0.25, 0.5, 1...6
副本数Number of replicas 44 44 44 44 44
Multi-AZMulti-AZ Yes Yes Yes Yes Yes
读取横向扩展Read Scale-out 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 IO 大小的最大值,范围为 8 KB 到 64 KB。1 The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.

2 如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制2 For the max concurrent workers (requests) for any individual database, see Single database resource limits. 例如,如果弹性池使用 Gen5 且每个数据库的最大 vCore 数设置为 2,则最大并发辅助角色数目值为 200。For example, if the elastic pool is using Gen5 and the max vCore per database is set at 2, then the max concurrent workers value is 200. 如果每个数据库的最大 vCore 数设置为 0.5,则最大并发辅助角色数目值为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is set to 0.5, then the max concurrent workers value is 50 since on Gen5 there are a max of 100 concurrent workers per vCore. 对于每个数据库的最大 vCore 设置小于 1 个 vCore 或更少的其他情况,最大并发辅助角色数会相应重新缩放。For other max vCore settings per database that are less 1 vCore or less, the number of max concurrent workers is similarly rescaled.

“业务关键”服务层级:第 4 代计算平台(第 2 部分)Business critical service tier: Generation 4 compute platform (part 2)

计算大小Compute size 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 10 个10 1616 2424
内存 (GB)Memory (GB) 4949 5656 6363 7070 112112 159.5159.5
每个池的最大数据库数Max number DBs per pool 100100 100100 100100 100100 100100 100100
列存储支持Columnstore support 空值N/A 不适用N/A 空值N/A 空值N/A 空值N/A 不适用N/A
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) 77 88 9.59.5 1111 20 个20 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)
每个池的最大数据 IOPS 1Max data IOPS per pool 1 31,50031,500 36,00036,000 40,50040,500 45,00045,000 72,00072,000 96,00096,000
每个池的最大日志速率 (MBps)Max log rate per pool (MBps) 7070 8080 8080 8080 8080 8080
每个池的最大并发工作线程数(请求数)2Max concurrent workers per pool (requests) 2 14701470 16801680 18901890 21002100 33603360 50405040
每个池的最大并发登录数(请求数)2Max concurrent logins per pool (requests) 2 14701470 16801680 18901890 21002100 33603360 50405040
最大并发会话数Max concurrent sessions 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000
每个数据库的最小/最大弹性池 vCore 选项Min/max elastic pool vCore choices per database 0, 0.25, 0.5, 1...70, 0.25, 0.5, 1...7 0, 0.25, 0.5, 1...80, 0.25, 0.5, 1...8 0, 0.25, 0.5, 1...90, 0.25, 0.5, 1...9 0, 0.25, 0.5, 1...100, 0.25, 0.5, 1...10 0, 0.25, 0.5, 1...10, 160, 0.25, 0.5, 1...10, 16 0, 0.25, 0.5, 1...10, 16, 240, 0.25, 0.5, 1...10, 16, 24
副本数Number of replicas 44 44 44 44 44 44
Multi-AZMulti-AZ Yes Yes Yes Yes Yes Yes
读取横向扩展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

1 IO 大小的最大值,范围为 8 KB 到 64 KB。1 The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.

2 如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制2 For the max concurrent workers (requests) for any individual database, see Single database resource limits. 例如,如果弹性池使用 Gen5 且每个数据库的最大 vCore 数设置为 2,则最大并发辅助角色数目值为 200。For example, if the elastic pool is using Gen5 and the max vCore per database is set at 2, then the max concurrent workers value is 200. 如果每个数据库的最大 vCore 数设置为 0.5,则最大并发辅助角色数目值为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is set to 0.5, then the max concurrent workers value is 50 since on Gen5 there are a max of 100 concurrent workers per vCore. 对于每个数据库的最大 vCore 设置小于 1 个 vCore 或更少的其他情况,最大并发辅助角色数会相应重新缩放。For other max vCore settings per database that are less 1 vCore or less, the number of max concurrent workers is similarly rescaled.

业务关键 - 预配的计算 - Gen5Business critical - provisioned compute - Gen5

“业务关键”服务层级:第 5 代计算平台(第 1 部分)Business critical service tier: Generation 5 compute platform (part 1)

计算大小Compute size 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
vCore 数vCores 44 66 88 10 个10 1212 1414
内存 (GB)Memory (GB) 20.820.8 31.131.1 41.541.5 51.951.9 62.362.3 72.772.7
每个池的最大数据库数Max number DBs per pool 5050 100100 100100 100100 100100 100100
列存储支持Columnstore support Yes Yes Yes Yes Yes Yes
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) 3.143.14 4.714.71 6.286.28 8.658.65 11.0211.02 13.3913.39
最大数据大小 (GB)Max data size (GB) 10241024 15361536 15361536 15361536 30723072 30723072
最大日志大小 (GB)Max log size (GB) 307307 307307 461461 461461 922922 922922
TempDB 最大数据大小 (GB)TempDB max data size (GB) 128128 192192 256256 320320 384384 448448
存储类型Storage type 本地 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)
每个池的最大数据 IOPS 1Max data IOPS per pool 1 18,00018,000 27,00027,000 36,00036,000 45,00045,000 54,00054,000 63,00063,000
每个池的最大日志速率 (MBps)Max log rate per pool (MBps) 6060 9090 120120 120120 120120 120120
每个池的最大并发工作线程数(请求数)2Max concurrent workers per pool (requests) 2 420420 630630 840840 10501050 12601260 14701470
每个池的最大并发登录数(请求数)2Max concurrent logins per pool (requests) 2 420420 630630 840840 10501050 12601260 14701470
最大并发会话数Max concurrent sessions 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000
每个数据库的最小/最大弹性池 vCore 选项Min/max elastic pool vCore choices per database 0, 0.25, 0.5, 1...40, 0.25, 0.5, 1...4 0, 0.25, 0.5, 1...60, 0.25, 0.5, 1...6 0, 0.25, 0.5, 1...80, 0.25, 0.5, 1...8 0, 0.25, 0.5, 1...100, 0.25, 0.5, 1...10 0, 0.25, 0.5, 1...120, 0.25, 0.5, 1...12 0, 0.25, 0.5, 1...140, 0.25, 0.5, 1...14
副本数Number of replicas 44 44 44 44 44 44
Multi-AZMulti-AZ Yes Yes Yes Yes Yes Yes
读取横向扩展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

1 IO 大小的最大值,范围为 8 KB 到 64 KB。1 The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.

2 如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制2 For the max concurrent workers (requests) for any individual database, see Single database resource limits. 例如,如果弹性池使用 Gen5 且每个数据库的最大 vCore 数设置为 2,则最大并发辅助角色数目值为 200。For example, if the elastic pool is using Gen5 and the max vCore per database is set at 2, then the max concurrent workers value is 200. 如果每个数据库的最大 vCore 数设置为 0.5,则最大并发辅助角色数目值为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is set to 0.5, then the max concurrent workers value is 50 since on Gen5 there are a max of 100 concurrent workers per vCore. 对于每个数据库的最大 vCore 设置小于 1 个 vCore 或更少的其他情况,最大并发辅助角色数会相应重新缩放。For other max vCore settings per database that are less 1 vCore or less, the number of max concurrent workers is similarly rescaled.

“业务关键”服务层级:第 5 代计算平台(第 2 部分)Business critical service tier: Generation 5 compute platform (part 2)

计算大小Compute size 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 20 个20 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
每个池的最大数据库数Max number DBs per pool 100100 100100 100100 100100 100100 100100 100100
列存储支持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.68131.68
最大数据大小 (GB)Max data size (GB) 30723072 30723072 30723072 40964096 40964096 40964096 40964096
最大日志大小 (GB)Max log size (GB) 922922 922922 922922 12291229 12291229 12291229 12291229
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 1Max data IOPS per pool 1 72,00072,000 81,00081,000 90,00090,000 108,000108,000 144,000144,000 180,000180,000 256,000256,000
每个池的最大日志速率 (MBps)Max log rate per pool (MBps) 120120 120120 120120 120120 120120 120120 120120
每个池的最大并发工作线程数(请求数)2Max concurrent workers per pool (requests) 2 16801680 18901890 21002100 25202520 33603360 42004200 84008400
每个池的最大并发登录数(请求数)2Max concurrent logins per pool (requests) 2 16801680 18901890 21002100 25202520 33603360 42004200 84008400
最大并发会话数Max concurrent sessions 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000 30,00030,000
每个数据库的最小/最大弹性池 vCore 选项Min/max elastic pool vCore choices per database 0, 0.25, 0.5, 1...160, 0.25, 0.5, 1...16 0, 0.25, 0.5, 1...180, 0.25, 0.5, 1...18 0, 0.25, 0.5, 1...200, 0.25, 0.5, 1...20 0, 0.25, 0.5, 1...20, 240, 0.25, 0.5, 1...20, 24 0, 0.25, 0.5, 1...20, 24, 320, 0.25, 0.5, 1...20, 24, 32 0, 0.25, 0.5, 1...20, 24, 32, 400, 0.25, 0.5, 1...20, 24, 32, 40 0, 0.25, 0.5, 1...20, 24, 32, 40, 800, 0.25, 0.5, 1...20, 24, 32, 40, 80
副本数Number of replicas 44 44 44 44 44 44 44
Multi-AZMulti-AZ Yes Yes Yes Yes Yes Yes Yes
读取横向扩展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

1 IO 大小的最大值,范围为 8 KB 到 64 KB。1 The maximum value for IO sizes ranging between 8 KB and 64 KB. 实际 IOPS 与工作负荷相关。Actual IOPS are workload-dependent.

2 如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制2 For the max concurrent workers (requests) for any individual database, see Single database resource limits. 例如,如果弹性池使用 Gen5 且每个数据库的最大 vCore 数设置为 2,则最大并发辅助角色数目值为 200。For example, if the elastic pool is using Gen5 and the max vCore per database is set at 2, then the max concurrent workers value is 200. 如果每个数据库的最大 vCore 数设置为 0.5,则最大并发辅助角色数目值为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is set to 0.5, then the max concurrent workers value is 50 since on Gen5 there are a max of 100 concurrent workers per vCore. 对于每个数据库的最大 vCore 设置小于 1 个 vCore 或更少的其他情况,最大并发辅助角色数会相应重新缩放。For other max vCore settings per database that are less 1 vCore or less, the number of max concurrent workers is similarly rescaled.

如果弹性池的所有 vCore 繁忙,则池中的每个数据库将接收相同数量的计算资源来处理查询。If all vCores of an elastic pool are busy, then each database in the pool receives an equal amount of compute resources to process queries. SQL 数据库服务通过确保相等的计算时间片段,在数据库之间提供资源共享的公平性。The SQL Database service provides resource sharing fairness between databases by ensuring equal slices of compute time. 弹性池资源共享公平性是在将每个数据库的 vCore 最小值设为非零值时,对另外为每个数据库保证的任意资源量的补充。Elastic pool resource sharing fairness is in addition to any amount of resource otherwise guaranteed to each database when the vCore min per database is set to a non-zero value.

共用数据库的数据库属性Database properties for pooled databases

下表介绍了共用数据库的属性。The following table describes the properties for pooled databases.

Note

弹性池中单个数据库的资源限制通常与池外部具有相同计算大小的单一数据库相同。The resource limits of individual databases in elastic pools are generally the same as for single databases outside of pools that has the same compute size. 例如,GP_Gen4_1 数据库的最大并发工作进程数为 200 个。For example, the max concurrent workers for an GP_Gen4_1 database is 200 workers. 因此,GP_Gen4_1 池中数据库的最大并发工作进程数也是 200 个。So, the max concurrent workers for a database in a GP_Gen4_1 pool is also 200 workers. 请注意,GP_Gen4_1 池中的并发工作进程总数为 210 个。Note, the total number of concurrent workers in GP_Gen4_1 pool is 210.

属性Property 说明Description
每个数据库的最大 vCore 数Max vCores per database 根据池中其他数据库的 vCore 使用率,池中任何数据库可以使用的 vCore 的最大数目。The maximum number of vCores that any database in the pool may use, if available based on utilization by other databases in the pool. 每个数据库的 vCore 上限并不是数据库的资源保障。Max vCores per database is not a resource guarantee for a database. 这是应用于池中所有数据库的全局设置。This setting is a global setting that applies to all databases in the pool. 将每个数据库的最大 vCore 数设置得足够高,以处理数据库使用高峰情况。Set max vCores per database high enough to handle peaks in database utilization. 因为池通常会假定数据库存在热使用模式和冷使用模式,在这些模式中并非所有数据库同时处于高峰使用状态,所以预期会存在某种程度的过量使用情况。Some degree of over-committing is expected since the pool generally assumes hot and cold usage patterns for databases where all databases are not simultaneously peaking.
每个数据库的最小 vCore 数Min vCores per database 池中任何数据库可以保证的 vCore 最小数目。The minimum number of vCores that any database in the pool is guaranteed. 这是应用于池中所有数据库的全局设置。This setting is a global setting that applies to all databases in the pool. 每个数据库的最小 vCore 可能设为 0,这也是默认值。The min vCores per database may be set to 0, and is also the default value. 该属性值可以设置为介于 0 和每个数据库的平均 vCore 使用量之间的任意值。This property is set to anywhere between 0 and the average vCores utilization per database. 池中数据库数目和每个数据库的 vCore 下限的积不能超过每个池的 vCore 数。The product of the number of databases in the pool and the min vCores per database cannot exceed the vCores per pool.
每个数据库的最大存储Max storage per database 用户为池中的数据库设置的最大数据库大小。The maximum database size set by the user for a database in a pool. 共用数据库共享分配的池存储,因此数据库可以访问的大小限制为剩余的池存储与数据库大小中的较小者。Pooled databases share allocated pool storage, so the size a database can reach is limited to the smaller of remaining pool storage and database size. 最大数据库大小是指数据文件的最大大小,不包括日志文件使用的空间。Max database size refers to the maximum size of the data files and does not include the space used by log files.

后续步骤Next steps