Does DTU selection act as a cap on cost?

Joshua Payne 21 Reputation points
2020-11-10T16:49:58.66+00:00

I’m hoping to gain a clearer understanding of Azure SQL DB pricing framework, using the DTU model. For the avoidance of doubt, - yes I have read MS docs literature, however it still isn’t easy to grasp. My question: Using the below screenshot as a point of reference. When setting up a Azure SQL Db - while selecting the DTU & memory settings - Does the selected DTU setting act as a cap on cost? For example: if I were to set my required DTU maximum to 10 DTUs (labelled "A" in screenshot) and GB database size 250 GB (see "B" on screenshot) and the Azure port showed me an estimated monthly running cost of say $19.20 dollars (using $ just for illustration, see "C" on screenshot), does this act as a maximum running cost celling - of course excluding any changes to future DTU cost or taxes etc. I.e. the Azure cloud service limits compute and storage to set range (quantified as a DTU), so as long as my use of the DB is no more than the max DTU limit my DB cost can't exceed what is quoted? ![38768-dtu-as-max-cost-cap.png][1] [1]: /api/attachments/38768-dtu-as-max-cost-cap.png?platform=QnA

Azure SQL Database
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,691 questions
0 comments No comments
{count} votes

Accepted answer
  1. David Browne - msft 3,851 Reputation points
    2020-11-10T16:57:37.753+00:00

    Does the selected DTU setting act as a cap on cost?

    Yes. You are paying for the reserved compute, memory, and storage resources. You cannot exceed your selected DTU limit and the charges are based on the configured DTUs and storage.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.