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条答案
按热度按时间db2dz4w81#
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.