使用 DTU 购买模型的单一数据库的资源限制 - Azure SQL 数据库Resource limits for single databases using the DTU purchasing model - Azure SQL Database
适用于：
Azure SQL 数据库
本文提供了针对使用 DTU 购买模型的 Azure SQL 数据库的单一数据库的详细资源限制。This article provides the detailed resource limits for Azure SQL Database single databases using the DTU purchasing model.
- 有关服务器上单一数据库的 DTU 购买模型限制，请参阅服务器上的资源限制概述。For DTU purchasing model limits for single databases on a server, see Overview of resource limits on a server.
- 有关 Azure SQL 数据库的 DTU 购买模型资源限制，请参阅 DTU 资源限制单一数据库和 DTU 资源限制弹性池。For DTU purchasing model resource limits for Azure SQL Database, see DTU resource limits single databases and DTU resource limits elastic pools.
- 有关 vCore 资源限制，请参阅 vCore 资源限制 - Azure SQL 数据库和 vCore 资源限制 - 弹性池。For vCore resource limits, see vCore resource limits - Azure SQL Database and vCore resource limits - elastic pools.
- 有关不同购买模型的更多信息，请参阅购买模型和服务层级。For more information regarding the different purchasing models, see Purchasing models and service tiers.
每个只读副本都有自己的资源，如 DTU、辅助角色和会话。Each read-only replica has its own resources such as DTUs, workers, and sessions. 每个只读副本都受限于本文后面详细介绍的资源限制。Each read-only replica is subject to the resource limits detailed later in this article.
单一数据库：存储大小和计算大小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. 可以通过以下方式为单一数据库设置服务层级、计算大小和存储量：You can set the service tier, compute size, and storage amount for a single database using:
- Transact-SQL（通过 ALTER DATABASE）Transact-SQL via ALTER DATABASE
- Azure 门户Azure portal
- PowerShellPowerShell
- Azure CLIAzure CLI
- REST APIREST 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 | 1010 | 2020 | 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
- 有关单一数据库的 vCore 资源限制，请参阅使用 vCore 购买模型的单一数据库的资源限制For vCore resource limits for a single database, see resource limits for single databases using the vCore purchasing model
- 有关弹性池的 vCore 资源限制，请参阅使用 vCore 购买模型的弹性池的资源限制For vCore resource limits for elastic pools, see resource limits for elastic pools using the vCore purchasing model
- 有关弹性池的 DTU 资源限制，请参阅使用 DTU 购买模型的弹性池的资源限制For DTU resource limits for elastic pools, see resource limits for elastic pools using the DTU purchasing model
- 有关 Azure SQL 托管实例中的托管实例的资源限制，请参阅 SQL 托管实例资源限制。For resource limits for managed instances in Azure SQL Managed Instance, see SQL Managed Instance resource limits.
- 有关常规 Azure 限制的相关信息，请参阅 Azure 订阅和服务限制、配额和约束。For information about general Azure limits, see Azure subscription and service limits, quotas, and constraints.
- 有关逻辑 SQL 服务器上的资源限制的信息，请参阅逻辑 SQL 服务器资源限制概述了解有关服务器级别和订阅级别限制的信息。For information about resource limits on a logical SQL server, see overview of resource limits on a logical SQL server for information about limits at the server and subscription levels.