Azure SQL 数据库“DTU 百分比"公制 [英] Azure SQL Database "DTU percentage" metric
问题描述
使用新的 DTU 提供了一种方法描述基本性能级别的相对容量，标准和高级数据库.DTU 基于混合度量CPU、内存、读取和写入.随着 DTU 的增加，提供的功率随着性能水平的提高.例如，性能级别具有 5 个 DTU 的功率是具有 1 个 DTU 的性能级别的五倍数据单元.最大 DTU 配额适用于每台服务器.
DTU 配额适用于服务器，而不是单个数据库，每个服务器最多有 1600 个 DTU.DTU% 是您的特定数据库使用的单位百分比，这个数字似乎可以超过服务层的 DTU 评级的 100%(我假设是服务器的限制).此百分比数字旨在帮助您选择合适的服务层级.
从下到底部 此公告:
<块引用>例如，如果您的 DTU 消耗显示值为 80%，则它表示它正在以 S2 限制的 80% 的速率消耗 DTU数据库会有.如果您在此视图中看到大于 100% 的值这意味着您需要一个大于 S2 的性能层.
例如，假设您看到的百分比值为 300%.这个告诉您您使用的资源比实际使用的资源多三倍在 S2 中可用.要确定合理的起始大小，请比较S2 (50 DTU) 中可用的 DTU，具有更高的尺寸 (P1 =100 个 DTU，或 S2 的 200%，P2 = 200 个 DTU 或 S2 的 400%).因为你处于 S2 的 300%，您希望从 P2 开始并重新测试.
With the new Azure SQL Database tier structure, it seems important to monitor your database "DTU" usage to know whether to upgrade or downgrade to another tier.
When reading Azure SQL Database Service Tiers and Performance Levels, it only talks about monitoring with CPU, Data and Log percentage usage.
But, when I add new metrics, I also have an DTU percentage option:
I can't find any about this online. Is this essentially a summary of the other DTU-related metrics?
A DTU is a unit of measure for the performance of a service tier and is a summary of several database characteristics. Each service tier has a certain number of DTUs assigned to it as an easy way to compare the performance level of one tier versus another.
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.
The DTU Quota applies to the server, not the individual databases and each server has a maximum of 1600 DTUs. The DTU% is the percentage of units your particular database is using and it seems that this number can go over 100% of the DTU rating of the service tier (I assume to the limit of the server). This percentage number is designed to help you choose the appropriate service tier.
From down toward the bottom of 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.
这篇关于Azure SQL 数据库“DTU 百分比"公制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
