CODEWITHSUNDEEP
azure-sql-database
tmaj
tmaj

Reputation: 35135

How often are Azure Database Transaction Unit (DTU) averaged?

Are DTU limits always like a policeman with a speed gun who just looks at your current speed and if it is above then you're busted or is like two cameras on a highway that measure your average speed?

If it is an average how small is the window?

Upvotes: 2

Views: 269

Answers (1)

TheGameiswar
TheGameiswar

Reputation: 28940

Your database is controlled using Resource Governor and when the queries are in need of any resource like IO,CPU,Memory after exhausting their limits..They will be in queue ..This has been documented here..

One of the design goals of the Basic, Standard, and Premium service tiers is for Azure SQL Database to behave as if the database is running on its own machine, completely isolated from other databases. Resource governance emulates this behavior.

If the aggregated resource utilization reaches the maximum available CPU, Memory, Log I/O, and Data I/O resources assigned to the database, resource governance will queue queries in execution and assign resources to the queued queries as they free up.

Upvotes: 1

Related Questions