英文:
What is a transaction units for Azure SQL Database
问题
创建 Azure SQL Database（SQL Server 的云版本）免费账户时，会提及 10 个数据库事务单位。
我对 SQL Server 中的事务非常了解。例如，如果我执行一个 INSERT 查询，即使我没有显式启动一个事务，它也会启动一个事务。
但是，什么是事务单位？和事务一样吗？我觉得并不是。如果是这样，使用时间太短了。我可以用这有限的使用做些什么？
英文:
When you create a Azure SQL Database (Cloud version of SQL Server) free account, it informs about 10 database transaction units.
I know clearly about transactions in SQL Server. For example, if I do a INSERT query, even if I don't explicitly start a transaction, it would start a transaction.
But, what is a transaction unit? Just same with a transaction? I don't think so. If so, the usage is too short. What can I do with that limited usage?
答案1
得分: 2
数据库事务单位（DTU）与数据库事务无关。以下是来自基于DTU的购买模型页面的官方定义：
数据库事务单位（DTU）代表了CPU、内存、读取和写入的混合度量。
DTU在基于DTU的购买模型中用于提供可用资源的相对指标。例如，从S0服务层级（10个DTU）升级到S1（20个DTU）将使CPU、内存和IO资源翻倍。
英文:
> what is a transaction unit? Just same with a transaction? I don't
> think so.
You are correct that database transaction units are unrelated to database transactions. Below is an excerpt from the DTU-based purchasing model page with the official definition:
> A database transaction unit (DTU) represents a blended measure of CPU,
> memory, reads, and writes.
DTUs are used in the DTU-based purchasing model to provide a relative indicator of available resources. For example, increasing from an S0 service tier (10 DTUs) to S1 (20 DTUs) will double CPU, memory, and IO resources.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论