DTU [英] DTU

问题描述

我正在研究DTU.虽然，我的确知道这是对CPU，内存，I/O周期的综合衡量.但是，我想知道确切算作1 DTU(以非专业人士的说法).

例如，如果我正在销售点系统上处理事务，那么如果我正在将数据从Azure映射到Power BI以进行报告并且生成报告或刷新现有报告，将其计为1 DTU或更多.

对不起，我刚刚开始提交此文件，但并没有很好的了解.

谢谢.

Umran

解决方案

数据库交易单元DTU是对以下资源的度量单位:保证可以以特定的性能级别提供给Azure SQL数据库.

• 衡量数据库的功能！
• 混合{CPU +内存+数据IO +日志IO}
• 它基于Microsoft OLTP基准.
• 更高的DTU提供更高的吞吐量

DTU是衡量服务层性能的度量单位，并且是几个数据库特征的摘要.每个服务层均分配有一定数量的DTU 这是比较一层和另一层的性能水平的简便方法.

DTU提供了一种描述Basic性能水平相对容量的方法，标准和高级数据库. DTU基于对CPU，内存， 读取和写入.随着DTU的增加，性能级别提供的功率也会增加.例如，具有5个DTU的性能水平的功率是具有1个DTU的性能水平的五倍.最大DTU配额适用于每台服务器.

示例: DTU性能

• 基本=> 5个DTU => 10个查询=> 60秒
• Standard => 100 DTU => 10个查询=> 3秒
• Premium => 1000 DTU => 10个查询=> 0.3秒

示例: 外行条款=> KTM自行车性能.

<身体>

规格(等级)	基本	标准	优质的
自行车名称	KTM 125公爵	KTM 200公爵	KTM 390
引擎CC(CPU)	124.7 cc	199.5 cc	373.2 cc
最大功率(内存)	14.5马力@ 9250 rpm	25 bhp @ 10000 rpm	43马力@ 9000 rpm
速度0-100 kmph(R/W)	14秒	9秒	5秒

有关详细信息，请参阅"DTU购买模型"，"什么是DTU?".

希望这会有所帮助.

Hi,

I'm researching on DTU. While, I do understand that its a blended measure of CPU, memory, I/o cycles. However, I want to know what exactly counts as 1 DTU (in layman terms). 

For example, if I'm processing a transaction on a Point of Sales system, would that transaction count as 1 DTU (or) if I'm mapping data from Azure to Power BI for reporting and if I generate a report or refresh the existing reports, would that count as 1 DTU or more.

Sorry, I have just started in this filed and don't have a great understanding. 

Thanks in advance.

Umran

解决方案

A Database Transaction Unit DTU is a unit of measure of the resources that are guaranteed to be available to an Azure SQL database at a specific performance level.

• Measures how powerful your database is!
• Blends of {CPU + Memory + Data IO + Log IO}
• It is based on a Microsoft OLTP benchmark.
• Higher DTUs provide higher throughput

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.

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.

Example: DTU Performance

• Basic => 5 DTUs => 10 queries => 60 seconds
• Standard => 100 DTUs => 10 queries => 3 seconds
• Premium => 1000 DTUs => 10 queries => 0.3 seconds

Example: layman terms => KTM Bike performance.

Specification (Tier)	Basic	Standard	Premium
Bike Name	KTM 125 Duke	KTM 200 Duke	KTM 390
Engine CC (CPU)	124.7 cc	199.5 cc	373.2 cc
Max Power (Memory)	14.5 bhp @ 9250 rpm	25 bhp @ 10000 rpm	43 bhp @ 9000 rpm
Speed 0-100 kmph (R/W)	14 seconds	9 seconds	5 seconds

For more details, refer "DTU purchasing model", "DTU-based service tiers" and "What the heck is a DTU?".

Hope this helps.

这篇关于DTU的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！