使用以 DTU 為基礎的購買模型的彈性集區資源限制Resources limits for elastic pools using the DTU-based purchasing model

本文使用以 DTU 為基礎的購買模型,來提供 Azure SQL Database 彈性集區和集區資料庫的詳細資源限制。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. 如需以虛擬核心為基礎的資源限制,請參閱以虛擬核心為基礎的資源限制 - 單一資料庫以虛擬核心為基礎的資源限制 - 彈性集區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 Database 彈性集區,下表顯示每個服務層級與計算大小的可用資源。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.

重要

調整指引和考量,請參閱調整彈性集區For scaling guidance and considerations, see Scale an elastic pool

注意

根據 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

每集區 eDTUeDTUs 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/AN/A N/AN/A N/AN/A N/AN/A N/AN/A N/AN/A N/AN/A N/AN/A
每個集區的最大 DB 數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

每集區 eDTUeDTUs 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/AN/A N/AN/A N/AN/A N/AN/A N/AN/A N/AN/A
每個集區的最大 DB 數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)

每集區 eDTUeDTUs 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/AN/A N/AN/A N/AN/A N/AN/A N/AN/A
每個集區的最大 DB 數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

每集區 eDTUeDTUs 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
每個集區的最大 DB 數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)

每集區 eDTUeDTUs 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
每個集區的最大 DB 數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

重要

所有區域目前均可使用進階層中超過 1 TB 的儲存體,但下列區域除外:中國東部、中國北部、德國中部、德國東北部、美國中西部、美國 DoD 區域和美國政府中部。More than 1 TB of storage in the Premium tier is currently available in all regions except: China East, China North, Germany Central, Germany Northeast, West Central US, US DoD regions, and US Government Central. 在這些區域中,進階層中的儲存空間上限為 1 TB。In these regions, the storage max in the Premium tier is limited to 1 TB. 如需詳細資訊,請參閱 P11-P15 目前的限制For more information, see P11-P15 current limitations.

如果彈性集區的所有 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 Database 服務藉由確保運算時間的均等配量,提供資料庫之間的資源共用公平性。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.

注意

針對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 數目上限,是否可用則是根據集區中其他資料庫的使用量而定。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 個 DTU,且集區中的 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