Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

What is a DTU?

If you are logged into the Unify Portal and navigate to Kusto actions > Performance > Perf Metric, you will be presented with the DTU Timeline, which details DTU consumption.

But what exactly is a DTU?

A DTU, or Database Transaction Unit, is a blended measure of CPU, memory, and disk resources.  This does not apply to on-premises Sql Server, but applies to our PaaS offering of SQL Server called Azure Sql Database, so only Azure-based D365FO customers should be concerned with this.  With Azure SQL Database, Microsoft guarantees a certain level of resources available to your database based on the selected service tier, making performance more predictable.  If your workload exceeds this level, throughput is throttled, which results in slower performance.

The DTU unit of measure is an easy-to-understand metric, especially when comparing between performance levels and service tiers.  Doubling the DTUs translates into doubling the amount of resources available for your Azure SQL Database.  Conversely, halving the DTUs in your service tier translates into halving the amount of resources available.

Share the post

What is a DTU?

×

Subscribe to Msdn Blogs | Get The Latest Information, Insights, Announcements, And News From Microsoft Experts And Developers In The Msdn Blogs.

Get updates delivered right to your inbox!

Thank you for your subscription

×