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

本文详细介绍了 Azure SQL 数据库中使用基于 DTU 的购买模型的弹性池和入池数据库的资源限制。This article provides the detailed resource limits for Azure SQL Database elastic pools and pooled databases using the DTU-based purchasing model.

若要了解使用基于 DTU 的购买模型的单一数据库的资源限制,请参阅基于 DTU 的资源限制 - 单一数据库For DTU-based purchasing model resource limits for single databases, see DTU-based resource limits - single databases. 有关基于 vCore 的资源限制,请参阅基于 vCore 的资源限制 - 单一数据库基于 vCore 的资源限制 - 弹性池For vCore-based resource limits, see vCore-based resource limits - single databases and vCore-based resource limits - elastic pools.

弹性池:存储大小和计算大小Elastic pool: Storage sizes and compute sizes

对于 SQL 数据库弹性池,下表显示了每个服务层级可用的资源和计算大小。For SQL Database elastic pools, the following tables show the resources available at each service tier and compute size. 可通过 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

Note

弹性池中各个数据库的资源限制通常与池外部基于 DTU 和服务层级的各个数据库相同。The resource limits of individual databases in elastic pools are generally the same as for single databases outside of pools based on DTUs and the service tier. 例如,S2 数据库的最大并发辅助进程数为 120 个。For example, the max concurrent workers for an S2 database is 120 workers. 因此,如果池中每个数据库的最大 DTU 是 50 个 DTU(这等效于 S2),则标准池中数据库的最大并发辅助进程数也是 120 个辅助进程。So, the max concurrent workers for a database in a Standard pool is also 120 workers if the max DTU per database in the pool is 50 DTUs (which is equivalent to S2).

基本弹性池限制Basic elastic pool limits

每个池的 eDTU 数eDTUs per pool 5050 100100 200200 300300 400400 800800 12001200 16001600
每个池包含的存储 (GB)Included storage per pool (GB) 55 1010 2020 2929 3939 7878 117117 156156
每个池的最大存储选择 (GB)Max storage choices per pool (GB) 55 1010 2020 2929 3939 7878 117117 156156
每个池的最大内存中 OLTP 存储 (GB)Max In-Memory OLTP storage per pool (GB) 不适用N/A 不适用N/A 不适用N/A 不适用N/A 不适用N/A 不适用N/A 不适用N/A 不适用N/A
每个池的最大数据库数Max number DBs per pool 100100 200200 500500 500500 500500 500500 500500 500500
每个池的最大并发工作线程数(请求数)Max concurrent workers (requests) per pool 100100 200200 400400 600600 800800 16001600 24002400 32003200
每个池的最大并发会话数Max concurrent sessions per pool 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小 eDTU 数选择Min eDTUs choices per database 0, 50, 5 0, 50, 5 0, 50, 5 0, 50, 5 0, 50, 5 0, 50, 5 0, 50, 5 0, 50, 5
每个数据库的最大 eDTU 数选择Max eDTUs choices per database 55 55 55 55 55 55 55 55
每个数据库的最大存储空间 (GB)Max storage per database (GB) 22 22 22 22 22 22 22 22

标准弹性池限制Standard elastic pool limits

每个池的 eDTU 数eDTUs per pool 5050 100100 200200 300300 400400 800800
每个池包含的存储 (GB)Included storage per pool (GB) 5050 100100 200200 300300 400400 800800
每个池的最大存储选择 (GB)Max storage choices per pool (GB) 50, 250, 50050, 250, 500 100, 250, 500, 750100, 250, 500, 750 200, 250, 500, 750, 1024200, 250, 500, 750, 1024 300, 500, 750, 1024, 1280300, 500, 750, 1024, 1280 400, 500, 750, 1024, 1280, 1536400, 500, 750, 1024, 1280, 1536 800, 1024, 1280, 1536, 1792, 2048800, 1024, 1280, 1536, 1792, 2048
每个池的最大内存中 OLTP 存储 (GB)Max In-Memory OLTP storage per pool (GB) 不适用N/A 不适用N/A 不适用N/A 不适用N/A 不适用N/A 不适用N/A
每个池的最大数据库数Max number DBs per pool 100100 200200 500500 500500 500500 500500
每个池的最大并发工作线程数(请求数)Max concurrent workers (requests) per pool 100100 200200 400400 600600 800800 16001600
每个池的最大并发会话数Max concurrent sessions per pool 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小 eDTU 数选择Min eDTUs choices per database 0, 10, 20, 500, 10, 20, 50 0, 10, 20, 50, 1000, 10, 20, 50, 100 0, 10, 20, 50, 100, 2000, 10, 20, 50, 100, 200 0, 10, 20, 50, 100, 200, 3000, 10, 20, 50, 100, 200, 300 0, 10, 20, 50, 100, 200, 300, 4000, 10, 20, 50, 100, 200, 300, 400 0, 10, 20, 50, 100, 200, 300, 400, 8000, 10, 20, 50, 100, 200, 300, 400, 800
每个数据库的最大 eDTU 数选择Max eDTUs choices per database 10, 20, 5010, 20, 50 10, 20, 50, 10010, 20, 50, 100 10, 20, 50, 100, 20010, 20, 50, 100, 200 10, 20, 50, 100, 200, 30010, 20, 50, 100, 200, 300 10, 20, 50, 100, 200, 300, 40010, 20, 50, 100, 200, 300, 400 10, 20, 50, 100, 200, 300, 400, 80010, 20, 50, 100, 200, 300, 400, 800
每个数据库的最大存储空间 (GB)Max storage per database (GB) 500500 750750 10241024 10241024 10241024 10241024

标准弹性池限制(续)Standard elastic pool limits (continued)

每个池的 eDTU 数eDTUs per pool 12001200 16001600 20002000 25002500 30003000
每个池包含的存储 (GB)Included storage per pool (GB) 12001200 16001600 20002000 25002500 30003000
每个池的最大存储选择 (GB)Max storage choices per pool (GB) 1200, 1280, 1536, 1792, 2048, 2304, 25601200, 1280, 1536, 1792, 2048, 2304, 2560 1600, 1792, 2048, 2304, 2560, 2816, 30721600, 1792, 2048, 2304, 2560, 2816, 3072 2000, 2048, 2304, 2560, 2816, 3072, 3328, 35842000, 2048, 2304, 2560, 2816, 3072, 3328, 3584 2500, 2560, 2816, 3072, 3328, 3584, 3840, 40962500, 2560, 2816, 3072, 3328, 3584, 3840, 4096 3000, 3072, 3328, 3584, 3840, 40963000, 3072, 3328, 3584, 3840, 4096
每个池的最大内存中 OLTP 存储 (GB)Max In-Memory OLTP storage per pool (GB) 不适用N/A 不适用N/A 不适用N/A 不适用N/A 不适用N/A
每个池的最大数据库数Max number DBs per pool 500500 500500 500500 500500 500500
每个池的最大并发工作线程数(请求数)Max concurrent workers (requests) per pool 24002400 32003200 40004000 50005000 60006000
每个池的最大并发会话数Max concurrent sessions per pool 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小 eDTU 数选择Min eDTUs choices per database 0, 10, 20, 50, 100, 200, 300, 400, 800, 12000, 10, 20, 50, 100, 200, 300, 400, 800, 1200 0, 10, 20, 50, 100, 200, 300, 400, 800, 1200, 16000, 10, 20, 50, 100, 200, 300, 400, 800, 1200, 1600 0, 10, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 20000, 10, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 2000 0, 10, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 2000, 25000, 10, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 2000, 2500 0, 10, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 2000, 2500, 30000, 10, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 2000, 2500, 3000
每个数据库的最大 eDTU 数选择Max eDTUs choices per database 10, 20, 50, 100, 200, 300, 400, 800, 120010, 20, 50, 100, 200, 300, 400, 800, 1200 10, 20, 50, 100, 200, 300, 400, 800, 1200, 160010, 20, 50, 100, 200, 300, 400, 800, 1200, 1600 10, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 200010, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 2000 10, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 2000, 250010, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 2000, 2500 10, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 2000, 2500, 300010, 20, 50, 100, 200, 300, 400, 800, 1200, 1600, 2000, 2500, 3000
每个数据库的最大存储空间选择 (GB)Max storage choices per database (GB) 10241024 10241024 10241024 10241024 10241024

高级弹性池限制Premium elastic pool limits

每个池的 eDTU 数eDTUs per pool 125125 250250 500500 10001000 15001500
每个池包含的存储 (GB)Included storage per pool (GB) 250250 500500 750750 10241024 15361536
每个池的最大存储选择 (GB)Max storage choices per pool (GB) 250, 500, 750, 1024250, 500, 750, 1024 500, 750, 1024500, 750, 1024 750, 1024750, 1024 10241024 15361536
每个池的最大内存中 OLTP 存储 (GB)Max In-Memory OLTP storage per pool (GB) 11 22 44 1010 1212
每个池的最大数据库数Max number DBs per pool 5050 100100 100100 100100 100100
每个池的最大并发工作线程数(请求数)Max concurrent workers per pool (requests) 200200 400400 800800 16001600 24002400
每个池的最大并发会话数Max concurrent sessions per pool 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小 eDTU 数Min eDTUs per database 0, 25, 50, 75, 1250, 25, 50, 75, 125 0, 25, 50, 75, 125, 2500, 25, 50, 75, 125, 250 0, 25, 50, 75, 125, 250, 5000, 25, 50, 75, 125, 250, 500 0, 25, 50, 75, 125, 250, 500, 10000, 25, 50, 75, 125, 250, 500, 1000 0, 25, 50, 75, 125, 250, 500, 1000, 15000, 25, 50, 75, 125, 250, 500, 1000, 1500
每个数据库的最大 eDTU 数Max eDTUs per database 25, 50, 75, 12525, 50, 75, 125 25, 50, 75, 125, 25025, 50, 75, 125, 250 25, 50, 75, 125, 250, 50025, 50, 75, 125, 250, 500 25, 50, 75, 125, 250, 500, 100025, 50, 75, 125, 250, 500, 1000 25, 50, 75, 125, 250, 500, 1000, 150025, 50, 75, 125, 250, 500, 1000, 1500
每个数据库的最大存储空间 (GB)Max storage per database (GB) 10241024 10241024 10241024 10241024 10241024

高级弹性池限制(续)Premium elastic pool limits (continued)

每个池的 eDTU 数eDTUs per pool 20002000 25002500 30003000 35003500 40004000
每个池包含的存储 (GB)Included storage per pool (GB) 20482048 25602560 30723072 35483548 40964096
每个池的最大存储选择 (GB)Max storage choices per pool (GB) 20482048 25602560 30723072 35483548 40964096
每个池的最大内存中 OLTP 存储 (GB)Max In-Memory OLTP storage per pool (GB) 1616 2020 2424 2828 3232
每个池的最大数据库数Max number DBs per pool 100100 100100 100100 100100 100100
每个池的最大并发工作线程数(请求数)Max concurrent workers (requests) per pool 32003200 40004000 48004800 56005600 64006400
每个池的最大并发会话数Max concurrent sessions per pool 3000030000 3000030000 3000030000 3000030000 3000030000
每个数据库的最小 eDTU 数选择Min eDTUs choices per database 0, 25, 50, 75, 125, 250, 500, 1000, 17500, 25, 50, 75, 125, 250, 500, 1000, 1750 0, 25, 50, 75, 125, 250, 500, 1000, 17500, 25, 50, 75, 125, 250, 500, 1000, 1750 0, 25, 50, 75, 125, 250, 500, 1000, 17500, 25, 50, 75, 125, 250, 500, 1000, 1750 0, 25, 50, 75, 125, 250, 500, 1000, 17500, 25, 50, 75, 125, 250, 500, 1000, 1750 0, 25, 50, 75, 125, 250, 500, 1000, 1750, 40000, 25, 50, 75, 125, 250, 500, 1000, 1750, 4000
每个数据库的最大 eDTU 数选择Max eDTUs choices per database 25, 50, 75, 125, 250, 500, 1000, 175025, 50, 75, 125, 250, 500, 1000, 1750 25, 50, 75, 125, 250, 500, 1000, 175025, 50, 75, 125, 250, 500, 1000, 1750 25, 50, 75, 125, 250, 500, 1000, 175025, 50, 75, 125, 250, 500, 1000, 1750 25, 50, 75, 125, 250, 500, 1000, 175025, 50, 75, 125, 250, 500, 1000, 1750 25, 50, 75, 125, 250, 500, 1000, 1750, 400025, 50, 75, 125, 250, 500, 1000, 1750, 4000
每个数据库的最大存储空间 (GB)Max storage per database (GB) 10241024 10241024 10241024 10241024 10241024

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

Note

有关 tempdb 限制,请参阅 tempdb 限制For tempdb limits, see tempdb limits.

入池数据库的数据库属性Database properties for pooled databases

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

属性Property 说明Description
每个数据库的最大 eDTU 数Max eDTUs per database 根据池中其他数据库的 eDTU 使用率,池中任何数据库可以使用的 eDTU 的最大数目。The maximum number of eDTUs that any database in the pool may use, if available based on utilization by other databases in the pool. 每个数据库的 eDTU 上限并不是数据库的资源保障。Max eDTU per database is not a resource guarantee for a database. 这是应用于池中所有数据库的全局设置。This setting is a global setting that applies to all databases in the pool. 将每个数据库的最大 eDTU 数设置得足够高,以处理数据库使用高峰情况。Set max eDTUs per database high enough to handle peaks in database utilization. 因为池通常会假定数据库存在热使用模式和冷使用模式,在这些模式中并非所有数据库同时处于高峰使用状态,所以预期会存在某种程度的过量使用情况。Some degree of overcommitting is expected since the pool generally assumes hot and cold usage patterns for databases where all databases are not simultaneously peaking. 例如,假设每个数据库的高峰使用量为 20 个 eDTU,并且池中 100 个数据库仅有 20% 同时处于高峰使用中。For example, suppose the peak utilization per database is 20 eDTUs and only 20% of the 100 databases in the pool are peak at the same time. 如果将每个数据库的 eDTU 最大值设为 20 个 eDTU,则可以认为超量 5 倍使用该池是合理的,并且将每个池的 eDTU 数设为 400。If the eDTU max per database is set to 20 eDTUs, then it is reasonable to overcommit the pool by 5 times, and set the eDTUs per pool to 400.
每个数据库的最小 eDTU 数Min eDTUs per database 池中任何数据库可以保证的 eDTU 最小数目。The minimum number of eDTUs that any database in the pool is guaranteed. 这是应用于池中所有数据库的全局设置。This setting is a global setting that applies to all databases in the pool. 每个数据库的最小 eDTU 可能设为 0,这也是默认值。The min eDTU per database may be set to 0, and is also the default value. 此属性值可以设置为介于 0 和每个数据库的平均 eDTU 使用量之间的任意值。This property is set to anywhere between 0 and the average eDTU utilization per database. 池中数据库的数目和每个数据库的 eDTU 下限的积不能超过每个池的 eDTU 数。The product of the number of databases in the pool and the min eDTUs per database cannot exceed the eDTUs per pool. 例如,如果一个池有 20 个数据库,每个数据库的 eDTU 最小值设为 10 个 eDTU,则池的 eDTU 数目必须大于或等于 200 个 eDTU。For example, if a pool has 20 databases and the eDTU min per database set to 10 eDTUs, then the eDTUs per pool must be at least as large as 200 eDTUs.
每个数据库的最大存储Max storage per database 用户为池中的数据库设置的最大数据库大小。The maximum database size set by the user for a database in a pool. 但是,入池数据库共享已分配的池存储。However, pooled databases share allocated pool storage. 即使每个数据库 的总存储空间上限设置为大于池的可用总存储 空间,所有数据库实际使用的总空间也不能超出可用的池限制。Even if the total max storage per database is set to be greater than the total available storage space of the pool, the total space actually used by all of the databases will not be able to exceed the available pool limit. 最大数据库大小是指数据文件的最大大小,不包括日志文件使用的空间。Max database size refers to the maximum size of the data files and does not include the space used by log files.

后续步骤Next steps