Azure SQL 数据库 "DTU percentage"指标

Question

有了新的Azure SQL Database tier structure ，监视数据库“DTU”使用情况以了解是否升级或降级到另一层似乎很重要。

阅读Azure SQL Database Service Tiers and Performance Levels时，它只讨论CPU、数据和日志百分比使用情况的监控。

但是，当我添加新指标时，我还有一个DTU 百分比选项:

我在网上找不到任何相关信息。这本质上是其他 DTU 相关指标的摘要吗？

Answer 1

DTU 是服务层性能的衡量单位，是多个数据库特性的汇总。每个服务层都分配有一定数量的 DTU，这是比较一个层与另一个层的性能水平的简单方法。

Database Throughput Unit (DTU): DTUs provide a way to describe the relative capacity of a performance level of Basic, Standard, and Premium databases. DTUs are based on a blended measure of CPU, memory, reads, and writes. As DTUs increase, the power offered by the performance level increases. For example, a performance level with 5 DTUs has five times more power than a performance level with 1 DTU. A maximum DTU quota applies to each server.

DTU 配额适用于服务器，而不是单个数据库，每台服务器最多有 1600 个 DTU。 DTU% 是您的特定数据库正在使用的单位的百分比，似乎这个数字可以超过服务层 DTU 评级的 100%(我假设是服务器的限制)。此百分比数字旨在帮助您选择合适的服务级别。

从下往下this announcement :

For example, if your DTU consumption shows a value of 80%, it indicates it is consuming DTU at the rate of 80% of the limit an S2 database would have. If you see values greater than 100% in this view it means that you need a performance tier larger than S2.

As an example, let’s say you see a percentage value of 300%. This tells you that you are using three times more resources than would be available in an S2. To determine a reasonable starting size, compare the DTUs available in an S2 (50 DTUs) with the next higher sizes (P1 = 100 DTUs, or 200% of S2, P2 = 200 DTUs or 400% of S2). Because you are at 300% of S2 you would want to start with a P2 and re-test.