CODEWITHSUNDEEP
sql-serverazureazure-sql-database
Sam
Sam

Reputation: 30334

Azure SQL Database DTU

I have multiple Azure SQL Databases and when I connect to them using SQL Server Management Studio, they all appear to be running on the same VM -- meaning, when I connect to the instance of SQL Server, I see my databases listed in Object Explorer.

With that said, should I assume that the DTU level set through the portal is only a throttling setting? In other words, should I assume that the databases are already running on a pretty powerful instance but based on DTU settings, Azure is throttling up/down allowed requests?

I don't think it would make a lot of sense for Microsoft to move a database to a new instance when the DTU level is increased.

Upvotes: 0

Views: 582

Answers (2)

Sirisha Chamarthi
Sirisha Chamarthi

Reputation: 1293

DTU is for individual databases, and can range from a small percentage of VM resources to the entire database taking one single machine. Azure doesn't guarantee all the databases under one server belongs to one physical sql server instance. The databases can potentially spread across multiple sql instances though they belongs to one logical server. For checks like firewall, it appears the instances cross connect to the master database and query the rules.

Upvotes: 0

4c74356b41
4c74356b41

Reputation: 72191

Yes, you are correct, DTU is not a VM total capacity, just a way to cap database performance.

Upvotes: 3

Related Questions