使用以 DTU 為基礎的購買模型的單一資料庫資源限制Resource limits for single databases using the DTU-based purchasing model

本文使用以 DTU 為基礎的購買模型,提供 Azure SQL Database 單一資料庫的詳細資源限制。This article provides the detailed resource limits for Azure SQL Database single databases using the DTU-based purchasing model.

如需適用於彈性集區的「以 DTU 為基礎的購買模型資源限制」,請參閱以 DTU 為基礎的資源限制 - 彈性集區For DTU-based purchasing model resource limits for elastic pools, see DTU-based resource limits - elastic pools. 如需以虛擬核心為基礎的資源限制,請參閱以虛擬核心為基礎的資源限制 - 單一資料庫以虛擬核心為基礎的資源限制 - 彈性集區For vCore-based resource limits, see vCore-based resource limits - single databases and vCore-based resource limits - elastic pools. 如需不同購買模型的詳細資訊,請參閱購買模型和服務層For more information regarding the different purchasing models, see Purchasing models and service tiers.

單一資料庫:儲存體大小與計算大小Single database: Storage sizes and compute sizes

下表顯示單一資料庫在每個服務層級和計算大小的可用資源。The following tables show the resources available for a single database at each service tier and compute size. 您可以使用 Azure 入口網站Transact-SQLPowerShellAzure CLIREST API 來為單一資料庫設定服務層、計算大小與儲存體數量。You can set the service tier, compute size, 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

基本服務層級Basic service tier

計算大小Compute size 基本Basic
最大 DTUMax DTUs 55
內含儲存體 (GB)Included storage (GB) 22
最大儲存體選擇 (GB)Max storage choices (GB) 22
OLTP 記憶體內部儲存體上限 (GB)Max in-memory OLTP storage (GB) N/AN/A
並行背景工作 (要求) 數上限Max concurrent workers (requests) 3030
並行工作階段數上限Max concurrent sessions 300300

標準服務層級Standard service tier

計算大小Compute size S0S0 S1S1 S2S2 S3S3
最大 DTUMax DTUs 1010 2020 5050 100100
內含儲存體 (GB)Included storage (GB) 250250 250250 250250 250250
最大儲存體選擇 (GB)Max storage choices (GB) 250250 250250 250250 250, 500, 750, 1024250, 500, 750, 1024
OLTP 記憶體內部儲存體上限 (GB)Max in-memory OLTP storage (GB) N/AN/A N/AN/A N/AN/A N/AN/A
並行背景工作 (要求) 數上限Max concurrent workers (requests) 6060 9090 120120 200200
並行工作階段數上限Max concurrent sessions 600600 900900 12001200 24002400

標準服務層級 (續)Standard service tier (continued)

計算大小Compute size S4S4 S6S6 S7S7 S9S9 S12S12
最大 DTUMax DTUs 200200 400400 800800 16001600 30003000
內含儲存體 (GB)Included storage (GB) 250250 250250 250250 250250 250250
最大儲存體選擇 (GB)Max storage choices (GB) 250, 500, 750, 1024250, 500, 750, 1024 250, 500, 750, 1024250, 500, 750, 1024 250, 500, 750, 1024250, 500, 750, 1024 250, 500, 750, 1024250, 500, 750, 1024 250, 500, 750, 1024250, 500, 750, 1024
OLTP 記憶體內部儲存體上限 (GB)Max in-memory OLTP storage (GB) N/AN/A N/AN/A N/AN/A N/AN/A N/AN/A
並行背景工作 (要求) 數上限Max concurrent workers (requests) 400400 800800 16001600 32003200 60006000
並行工作階段數上限Max concurrent sessions 48004800 96009600 1920019200 3000030000 3000030000

高階服務層級Premium service tier

計算大小Compute size P1P1 P2P2 P4P4 P6P6 P11P11 P15P15
最大 DTUMax DTUs 125125 250250 500500 10001000 17501750 40004000
內含儲存體 (GB)Included storage (GB) 500500 500500 500500 500500 4096 *4096* 4096 *4096*
最大儲存體選擇 (GB)Max storage choices (GB) 500, 750, 1024500, 750, 1024 500, 750, 1024500, 750, 1024 500, 750, 1024500, 750, 1024 500, 750, 1024500, 750, 1024 4096 *4096* 4096 *4096*
OLTP 記憶體內部儲存體上限 (GB)Max in-memory OLTP storage (GB) 11 22 44 88 1414 3232
並行背景工作 (要求) 數上限Max concurrent workers (requests) 200200 400400 800800 16001600 24002400 64006400
並行工作階段數上限Max concurrent sessions 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000

*從 1024 GB 到 4096 GB, 以 256 GB 為增量* From 1024 GB up to 4096 GB in increments of 256 GB

重要

所有區域目前均可使用進階層中超過 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.

注意

tempdb需限制, 請參閱tempdb 限制For tempdb limits, see tempdb limits.

後續步驟Next steps