DTU
and eDTU in Azure SQL
The performance of SQL Database is based on
DTU.
According to Microsoft,
a DTU is a unit of measure of the resources that are guaranteed to be available
to a single Azure SQL Database at a specific performance level within a single
database tier. A DTU combines CPU, memory, data I/O, and transaction I/O.
- Databases can be placed into an elastic pool on a SQL Database server that shares a pool of
resources among those databases. The shared pool of resources are measured
by elastic Database
transition units (eDTU).
- The advantages of an elastic pool are:
- They are scaled automatically.
- They provide predictable
costs.
- They are widely used for varying and unpredictable
usage patterns.
Determining DTUs for Workloads
·
If you are planning to move your
on-premises Databases to Azure SQL Database, Azure provides a DTU Calculator to find the approximate DTUs required for setting up the
database.
·
For an existing
Azure Database, you can use SQL Data query performance insight.
This Query performance insight provides a deeper insight into the resource
consumption (DTU's) of Database, the top queries by CPU/Duration/Execution
count, which can potentially be tuned for improved performance.
Great content
ReplyDelete