您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.

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

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

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

重要

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

重要

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

备注

弹性池中单个数据库的资源限制通常与池外部具有相同计算大小的单一数据库相同。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.

“常规用途”服务层级:存储大小和计算大小General Purpose service tier: Storage sizes and compute sizes

“常规用途”服务层级:第 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
硬件代次H/W generation 44 44 44 44 44 44
vCore 数vCores 1 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 756756 15361536 15361536 15361536
最大日志大小Max log size 154154 227227 227227 461461 461461 461461
TempDB 大小 (GB)TempDB 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 (64 KB)Target IOPS (64 KB) 500500 10001000 15001500 20002000 25002500 30003000
日志速率限制 (MBps)Log rate limits (MBps) 4.68754.6875 9.3759.375 14.062514.0625 18.7518.75 23.437523.4375 28.12528.125
每个池的最大并发工作线程数(请求数)*Max concurrent workers per pool (requests) * 210210 420420 630630 840840 10501050 12601260
每个池的最大并发登录数 *Max concurrent logins per pool * 210210 420420 630630 840840 10501050 12601260
允许的最大会话数Max allowed sessions 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小/最大弹性池 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 1 11 11 11 11 1
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

*如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制* 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 its max vCore per database is 2, then the max concurrent workers is 200. 如果每个数据库的最大 vCore 数为 0.5,则最大并发辅助角色数为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is 0.5, then the max concurrent workers 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
硬件代次H/W generation 44 44 44 44 44 44
vCore 数vCores 77 88 99 1010 1616 2424
内存 (GB)Memory (GB) 4949 5656 6363 7070 112112 168168
每个池的最大数据库数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) 15361536 20482048 20482048 20482048 35843584 40964096
最大日志大小 (GB)Max log size (GB) 461461 614614 614614 614614 10751075 12291229
TempDB 大小 (GB)TempDB size (GB) 224224 256256 288288 320320 384384 384384
存储类型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 (64 KB)Target IOPS (64 KB) 35003500 40004000 45004500 50005000 70007000 70007000
日志速率限制 (MBps)Log rate limits (MBps) 32.812532.8125 37.537.5 37.537.5 37.537.5 37.537.5 37.537.5
每个池的最大并发工作线程数(请求数)*Max concurrent workers per pool (requests) * 14701470 16801680 18901890 21002100 33603360 50405040
每个池的最大并发登录数(请求数)*Max concurrent logins pool (requests) * 14701470 16801680 18901890 21002100 33603360 50405040
允许的最大会话数Max allowed sessions 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小/最大弹性池 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 1 11 11 11 11 1
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

*如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制* 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 its max vCore per database is 2, then the max concurrent workers is 200. 如果每个数据库的最大 vCore 数为 0.5,则最大并发辅助角色数为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is 0.5, then the max concurrent workers 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 代计算平台(第 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
硬件代次H/W generation 55 55 55 55 55 55 55
vCore 数vCores 22 44 66 88 1010 1212 1414
内存 (GB)Memory (GB) 10.210.2 20.420.4 30.630.6 40.840.8 5151 61.261.2 71.471.4
每个池的最大数据库数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 756756 15361536 15361536 15361536
最大日志大小 (GB)Max log size (GB) 154154 227227 227227 461461 461461 461461 461461
TempDB 大小 (GB)TempDB size (GB) 6464 128128 192192 256256 320320 384384 384384
存储类型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 (64 KB)Target IOPS (64 KB) 10001000 20002000 30003000 40004000 50005000 60006000 70007000
日志速率限制 (MBps)Log rate limits (MBps) 4.68754.6875 9.3759.375 14.062514.0625 18.7518.75 23.437523.4375 28.12528.125 32.812532.8125
每个池的最大并发工作线程数(请求数)*Max concurrent workers per pool (requests) * 210210 420420 630630 840840 10501050 12601260 14701470
每个池的最大并发登录数(请求数)*Max concurrent logins per pool (requests) * 210210 420420 630630 840840 10501050 12601260 14701470
允许的最大会话数Max allowed sessions 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小/最大弹性池 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 1 11 11 11 11 11 1
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

*如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制* 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 its max vCore per database is 2, then the max concurrent workers is 200. 如果每个数据库的最大 vCore 数为 0.5,则最大并发辅助角色数为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is 0.5, then the max concurrent workers 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
硬件代次H/W generation 55 55 55 55 55 55 55
vCore 数vCores 1616 1818 2020 2424 3232 4040 8080
内存 (GB)Memory (GB) 81.681.6 91.891.8 102102 122.4122.4 163.2163.2 204204 408408
每个池的最大数据库数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 20482048 30723072 30723072 40964096 40964096 40964096
最大日志大小 (GB)Max log size (GB) 614614 614614 922922 922922 12291229 12291229 12291229
TempDB 大小 (GB)TempDB size (GB) 384384 384384 384384 384384 384384 384384 384384
存储类型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 (64 KB)Target IOPS (64 KB) 70007000 70007000 70007000 70007000 70007000 70007000 70007000
日志速率限制 (MBps)Log rate limits (MBps) 37.537.5 37.537.5 37.537.5 37.537.5 37.537.5 37.537.5 37.537.5
每个池的最大并发工作线程数(请求数)*Max concurrent workers per pool (requests) * 16801680 18901890 21002100 25202520 3360033600 42004200 84008400
每个池的最大并发登录数(请求数)*Max concurrent logins per pool (requests) * 16801680 18901890 21002100 25202520 3360033600 42004200 84008400
每个数据库的最小/最大弹性池 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 1 11 11 11 11 11 1
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

*如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制* 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 its max vCore per database is 2, then the max concurrent workers is 200. 如果每个数据库的最大 vCore 数为 0.5,则最大并发辅助角色数为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is 0.5, then the max concurrent workers 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.

“业务关键”服务层级:存储大小和计算大小Business Critical service tier: Storage sizes and compute sizes

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

计算大小Compute size 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
硬件代次H/W generation 44 44 44 44 44 44
vCore 数vCores 1 22 33 44 55 66
内存 (GB)Memory (GB) 77 1414 2121 2828 3535 4242
每个池的最大数据库数Max number DBs per pool 此计算大小仅支持单个 DBOnly single DBs are supported for this compute size 5050 100100 100100 100100 100100
列存储支持Columnstore support Yes Yes Yes Yes Yes Yes
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) 1 22 33 44 55 66
存储类型Storage type 本地 SSDLocal SSD 本地 SSDLocal SSD 本地 SSDLocal SSD 本地 SSDLocal SSD 本地 SSDLocal SSD 本地 SSDLocal SSD
最大数据大小 (GB)Max data size (GB) 650650 650650 650650 650650 650650 650650
最大日志大小 (GB)Max log size (GB) 195195 195195 195195 195195 195195 195195
TempDB 大小 (GB)TempDB 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 (64 KB)Target IOPS (64 KB) 50005000 1000010000 1500015000 2000020000 2500025000 3000030000
日志速率限制 (MBps)Log rate limits (MBps) 1010 2020 3030 4040 5050 6060
每个池的最大并发工作线程数(请求数)*Max concurrent workers per pool (requests) * 210210 420420 630630 840840 10501050 12601260
每个池的最大并发登录数(请求数)*Max concurrent logins per pool (requests) * 210210 420420 630630 840840 10501050 12601260
允许的最大会话数Max allowed sessions 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小/最大弹性池 vCore 选项Min/max elastic pool vCore choices per database 不适用N/A 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 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

*如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制* 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 its max vCore per database is 2, then the max concurrent workers is 200. 如果每个数据库的最大 vCore 数为 0.5,则最大并发辅助角色数为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is 0.5, then the max concurrent workers 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
硬件代次H/W generation 44 44 44 44 44 44
vCore 数vCores 77 88 99 1010 1616 2424
内存 (GB)Memory (GB) 81.681.6 91.891.8 102102 122.4122.4 163.2163.2 204204
每个池的最大数据库数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 2020 3636
存储类型Storage type 本地 SSDLocal SSD 本地 SSDLocal SSD 本地 SSDLocal SSD 本地 SSDLocal SSD 本地 SSDLocal SSD 本地 SSDLocal SSD
最大数据大小 (GB)Max data size (GB) 650650 650650 650650 650650 10241024 10241024
最大日志大小 (GB)Max log size (GB) 195195 195195 195195 195195 307307 307307
TempDB 大小 (GB)TempDB size (GB) 224224 256256 288288 320320 384384 384384
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 (64 KB)Target IOPS (64 KB) 3500035000 4000040000 4500045000 5000050000 8000080000 120000120000
日志速率限制 (MBps)Log rate limits (MBps) 7070 8080 8080 8080 8080 8080
每个池的最大并发工作线程数(请求数)*Max concurrent workers per pool (requests) * 14701470 16801680 18901890 21002100 33603360 50405040
每个池的最大并发登录数(请求数)*Max concurrent logins per pool (requests) * 14701470 16801680 18901890 21002100 33603360 50405040
允许的最大会话数Max allowed sessions 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小/最大弹性池 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

*如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制* 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 its max vCore per database is 2, then the max concurrent workers is 200. 如果每个数据库的最大 vCore 数为 0.5,则最大并发辅助角色数为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is 0.5, then the max concurrent workers 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 代计算平台(第 1 部分)Business Critical service tier: Generation 5 compute platform (part 1)

计算大小Compute size 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
硬件代次H/W generation 55 55 55 55 55 55 55
vCore 数vCores 22 44 66 88 1010 1212 1414
内存 (GB)Memory (GB) 10.210.2 20.420.4 30.630.6 40.840.8 5151 61.261.2 71.471.4
每个池的最大数据库数Max number DBs per pool 此计算大小仅支持单个 DBOnly single DBs are supported for this compute size 5050 100100 100100 100100 100100 100100
列存储支持Columnstore support Yes Yes Yes Yes Yes Yes Yes
内存中 OLTP 存储 (GB)In-memory OLTP storage (GB) 1.5711.571 3.1423.142 4.7134.713 6.2846.284 8.6558.655 11.02611.026 13.39713.397
最大数据大小 (GB)Max data size (GB) 10241024 10241024 15361536 15361536 15361536 30723072 30723072
最大日志大小 (GB)Max log size (GB) 307307 307307 307307 461461 461461 922922 922922
TempDB 大小 (GB)TempDB size (GB) 6464 128128 192192 256256 320320 384384 384384
存储类型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 (64 KB)Target IOPS (64 KB) 50005000 1000010000 1500015000 2000020000 2500025000 3000030000 3500035000
日志速率限制 (MBps)Log rate limits (MBps) 1515 3030 4545 6060 7575 9090 105105
每个池的最大并发工作线程数(请求数)*Max concurrent workers per pool (requests) * 210210 420420 630630 840840 10501050 12601260 14701470
每个池的最大并发登录数(请求数)*Max concurrent logins per pool (requests) * 210210 420420 630630 840840 10501050 12601260 14701470
允许的最大会话数Max allowed sessions 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小/最大弹性池 vCore 选项Min/max elastic pool vCore choices per database 不适用N/A 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 44
Multi-AZMulti-AZ 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

*如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制* 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 its max vCore per database is 2, then the max concurrent workers is 200. 如果每个数据库的最大 vCore 数为 0.5,则最大并发辅助角色数为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is 0.5, then the max concurrent workers 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
硬件代次H/W generation 55 55 55 55 55 55 55
vCore 数vCores 1616 1818 2020 2424 3232 4040 8080
内存 (GB)Memory (GB) 81.681.6 91.891.8 102102 122.4122.4 163.2163.2 204204 408408
每个池的最大数据库数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.76815.768 18.13918.139 20.5120.51 25.25225.252 37.93637.936 52.2252.22 131.64131.64
最大数据大小 (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 size (GB) 384384 384384 384384 384384 384384 384384 384384
存储类型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 (64 KB)Target IOPS (64 KB) 4000040000 4500045000 5000050000 6000060000 8000080000 100000100000 200000200000
日志速率限制 (MBps)Log rate limits (MBps) 120120 120120 120120 120120 120120 120120 120120
每个池的最大并发工作线程数(请求数)*Max concurrent workers per pool (requests) * 16801680 18901890 21002100 25202520 33603360 42004200 84008400
每个池的最大并发登录数(请求数)*Max concurrent logins per pool (requests) * 16801680 18901890 21002100 25202520 33603360 42004200 84008400
允许的最大会话数Max allowed sessions 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小/最大弹性池 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

*如需了解任何单个数据库的最大并发辅助角色数(请求数),请参阅单一数据库资源限制* 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 its max vCore per database is 2, then the max concurrent workers is 200. 如果每个数据库的最大 vCore 数为 0.5,则最大并发辅助角色数为 50,因为 Gen5 上每个 vCore 的最大并发辅助角色数为 100。If max vCore per database is 0.5, then the max concurrent workers 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.

属性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