Azure的SQL数据库＆QUOT; DTU百分比＆QUOT;公 [英] Azure SQL Database "DTU percentage" metric

问题描述

随着新 Azure的SQL数据库三层结构，监控似乎重要的数据库DTU用法知道是否升级或降级到另一个层次。

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.

在阅读 Azure的SQL数据库服务层和性能水平的，它只有大约会谈与CPU，数据和日志使用百分比进行监控。

When reading Azure SQL Database Service Tiers and Performance Levels, it only talks about monitoring with CPU, Data and Log percentage usage.

但是，当我添加新的指标，我也有一个 DTU百分比选项：

But, when I add new metrics, I also have an DTU percentage option:

我找不到任何有关这个网上。这是本质上是其它DTU相关的指标的总结？

I can't find any about this online. Is this essentially a summary of the other DTU-related metrics?

推荐答案

一个DTU是度量单位为服务层的性能，并且是多个数据库的特点的总结。每一个服务层分配有一种简单的方法来比较一层与另一的性能水平一定数量的DTU。

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.

数据库的吞吐量单元（DTU）： 的DTU提供一种方法来
  描述基本的性能水平的相对容量，
  Standard和premium数据库。的DTU基于共混度量
  CPU，内存，读取和写入。作为DTU的增加，功率提供
  由性能水平提高。例如，一个性能水平
  5 DTU的先后五次比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％评级（我假设到服务器的限制）。这个百分比数字旨在帮助您选择合适的服务层。

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.

这是朝着底部<下来href=\"http://azure.microsoft.com/blog/2014/09/11/azure-sql-database-introduces-new-near-real-time-performance-metrics/\">this公告：

例如，如果你的DTU消费显示出80％的值，
  表示这是在极限的S2的80％的速度消耗DTU
  数据库将有。如果您看到的值大于100％，在此视图
  这意味着你需要一个表现层比S2大。

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.

作为一个例子，假设你看到300％的百分比值。这个
  告诉你，你正在使用三次更多的资源会
  在S2可用。要确定一个合理的起始大小，比较
  在现有的DTU在S2（50 DTU的）下一个更高的尺寸（P1 =
  100的DTU，或S2的200％，P 2 = 200的DTU或S2的400％）。因为你
  是在S2的300％，你想开始一个P2和重新测试。

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数据库＆QUOT; DTU百分比＆QUOT;公的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！