使用 DTU 购买模型的单一数据库的资源限制 - Azure SQL 数据库Resource limits for single databases using the DTU purchasing model - Azure SQL Database

适用于:是Azure SQL 数据库 APPLIES TO: yesAzure SQL Database

本文提供了针对使用 DTU 购买模型的 Azure SQL 数据库的单一数据库的详细资源限制。This article provides the detailed resource limits for Azure SQL Database single databases using the DTU purchasing model.

有关弹性池的 DTU 购买模型资源限制,请参阅 DTU 资源限制 - 弹性池For DTU purchasing model resource limits for elastic pools, see DTU resource limits - elastic pools. 有关 vCore 资源限制,请参阅 vCore 资源限制 - 单一数据库vCore 资源限制 - 弹性池For vCore resource limits, see vCore resource limits - single databases and vCore 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
最大 DTU 数Max DTUs 55
包含的存储 (GB)Included storage (GB) 22
最大存储 (GB)Max storage (GB) 22
最大内存中 OLTP 存储 (GB)Max in-memory OLTP storage (GB) 空值N/A
最大并发工作线程数(请求数)Max concurrent workers (requests) 3030
最大并发会话数Max concurrent sessions 300300

重要

“基本”服务层级提供的 vCore (CPU) 不到一个。The Basic service tier provides less than one vCore (CPU). 对于 CPU 密集型工作负荷,建议使用 S3 或更高的服务层级。For CPU-intensive workloads, a service tier of S3 or greater is recommended.

有关数据存储的“基本”服务层级放置在标准页 Blob 上。Regarding data storage, the Basic service tier is placed on Standard Page Blobs. 标准页 Blob 使用基于硬盘驱动器 (HDD) 的存储介质,最适合用于对性能变化不太敏感的开发、测试和其他不频繁访问的工作负荷。Standard Page Blobs use hard disk drive (HDD)-based storage media and are best suited for development, testing, and other infrequently accessed workloads that are less sensitive to performance variability.

“标准”服务层级Standard service tier

计算大小Compute size S0S0 S1S1 S2S2 S3S3
最大 DTUMax DTUs 10 个10 20 个20 5050 100100
包含的存储 (GB) 1Included storage (GB) 1 250250 250250 250250 250250
最大存储 (GB)Max storage (GB) 250250 250250 250250 10241024
最大内存中 OLTP 存储 (GB)Max in-memory OLTP storage (GB) 空值N/A 空值N/A 空值N/A 空值N/A
最大并发工作线程数(请求数)Max concurrent workers (requests) 6060 9090 120120 200200
最大并发会话数Max concurrent sessions 600600 900900 12001200 24002400

1 请参阅 SQL 数据库定价选项,详细了解由于任何预配的额外存储导致的额外成本。1 See SQL Database pricing options for details on additional cost incurred due to any extra storage provisioned.

重要

标准 S0、S1 和 S2 层级提供的 vCore (CPU) 不到一个。The Standard S0, S1 and S2 tiers provide less than one vCore (CPU). 对于 CPU 密集型工作负荷,建议使用 S3 或更高的服务层级。For CPU-intensive workloads, a service tier of S3 or greater is recommended.

有关数据存储的标准 S0 和 S1 服务层级放置在标准页 Blob 上。Regarding data storage, the Standard S0 and S1 service tiers are placed on Standard Page Blobs. 标准页 Blob 使用基于硬盘驱动器 (HDD) 的存储介质,最适合用于对性能变化不太敏感的开发、测试和其他不频繁访问的工作负荷。Standard Page Blobs use hard disk drive (HDD)-based storage media and are best suited for development, testing, and other infrequently accessed workloads that are less sensitive to performance variability.

“标准”服务层级(续)Standard service tier (continued)

计算大小Compute size S4S4 S6S6 S7S7 S9S9 S12S12
最大 DTU 数Max DTUs 200200 400400 800800 16001600 30003000
包含的存储 (GB) 1Included storage (GB) 1 250250 250250 250250 250250 250250
最大存储 (GB)Max storage (GB) 10241024 10241024 10241024 10241024 10241024
最大内存中 OLTP 存储 (GB)Max in-memory OLTP storage (GB) 空值N/A 空值N/A 空值N/A 空值N/A 空值N/A
最大并发工作线程数(请求数)Max concurrent workers (requests) 400400 800800 16001600 32003200 60006000
最大并发会话数Max concurrent sessions 48004800 96009600 1920019200 3000030000 3000030000

1 请参阅 SQL 数据库定价选项,详细了解由于任何预配的额外存储导致的额外成本。1 See SQL Database pricing options for details on additional cost incurred due to any extra storage provisioned.

“高级”服务层级Premium service tier

计算大小Compute size P1P1 P2P2 P4P4 P6P6 P11P11 P15P15
最大 DTU 数Max DTUs 125125 250250 500500 10001000 17501750 40004000
包含的存储 (GB) 1Included storage (GB) 1 500500 500500 500500 500500 4096 24096 2 4096 24096 2
最大存储 (GB)Max storage (GB) 10241024 10241024 10241024 10241024 4096 24096 2 4096 24096 2
最大内存中 OLTP 存储 (GB)Max in-memory OLTP storage (GB) 11 22 44 88 1414 3232
最大并发工作线程数(请求数)Max concurrent workers (requests) 200200 400400 800800 16001600 28002800 64006400
最大并发会话数Max concurrent sessions 3000030000 3000030000 3000030000 3000030000 3000030000 3000030000

1 请参阅 SQL 数据库定价选项,详细了解由于任何预配的额外存储导致的额外成本。1 See SQL Database pricing options for details on additional cost incurred due to any extra storage provisioned.

2 从 1024 GB 到 4096 GB,以 256 GB 为增量。2 From 1024 GB up to 4096 GB in increments of 256 GB.

备注

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

后续步骤Next steps