Azure DTU计算 [英] Azure DTU Calculation

问题描述

我们在Azure上有一些数据库实例，我正在尝试优化Azure上的数据库性能。谁能解释什么是Azure DTU&我们如何计算Azure DTU？

We have some DB instances on Azure, I am trying to optimize DB Performance on Azure. Can any explain what is Azure DTU & How can we calculate Azure DTU ?

推荐答案

1。什么是Azure DTU：

1.What is Azure DTU:

Azure SQL数据库提供两种购买模型：基于vCore的购买模型和基于DTU的购买模型。

Azure SQL Database provides two purchasing models: vCore-based purchasing model and DTU-based purchasing model.

基于DTU的购买模型基于捆绑措施计算，存储和IO资源。计算大小用单个数据库的数据库事务单位（DTU）和弹性池的弹性数据库事务单位（eDTU）表示。

DTU-based purchasing model is based on a bundled measure of compute, storage, and IO resources. Compute sizes are expressed in terms of Database.Transaction Units (DTUs) for single databases and elastic Database Transaction Units (eDTUs) for elastic pools.

数据库事务单位（DTU） ）代表CPU，内存，读取和写入的混合量度。基于DTU的购买模型提供了一组预先配置的计算资源束，并包括存储以驱动不同级别的应用程序性能：基本，标准和高级。

The Database Transaction Unit (DTU) represents a blended measure of CPU, memory, reads, and writes. The DTU-based purchasing model offers a set of preconfigured bundles of compute resources and included storage to drive different levels of application performance: Basic, Standard and Premium.

更多信息，请参阅： https：// docs.microsoft.com/zh-cn/azure/sql-database/sql-database-service-tiers-dtu

2。如何优化数据库性能：

2.How to optimize DB Performance:

由于数据库实例已经在Azure上，因此可以通过故障排除或更改服务层来监视数据库实例并使用Azure Portal改善数据库性能。请参阅：监视和性能调整： https://docs.microsoft.com/zh-CN/azure/sql-database/sql-database-monitor-tune-overview#improving-database-performance-with-更多资源

Since your DB instances are already on Azure, you can monitor your DB instances and improve your DB Performance with Azure Portal by troubleshot or change the service tiers. Please see: Monitoring and performance tuning: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitor-tune-overview#improving-database-performance-with-more-resources

3。如何计算Azure DTU：

3.How to calculate Azure DTU:

此处是有关Azure SQL数据库DTU计算器。此计算器将帮助我们确定现有SQL Server数据库的DTU数量，并建议我们在迁移到Azure SQL数据库之前需要的最低性能级别和服务层。
如果您仍然保留数据库备份文件，我想您可以尝试使用此计算器。

Here is a link about Azure SQL Database DTU Calculator.This calculator will help us determine the number of DTUs for our existing SQL Server database(s) as well as a recommendation of the minimum performance level and service tier that we need before we migrate to Azure SQL Database. If you still keep the database backup file, i think you can try this calculator.

请参阅： http://dtucalculator.azurewebsites.net/

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