Hi @Yao Lu , welcome to Microsoft Q&A forum.
As I read the question, you want to understand how will autoscale work with multiple containers in same database vs individual container in separate databases.
Multiple Container in Same Database ("Container A" and "Container B" both in "Database 1")
In this case, when we create the database we have an option of selecting 'Shared throughput across container' as mentioned in below screenshot. So if we set up a autoscale Max throughput of 4000 RU/s and create 2 containers A and B, then this throughput will be shared among these 2. Now at the peak of consumption if one container is consuming lets say 3000 RU/s then other will have the bandwidth to consume only 1000 RU/s. Hence throughput will be shared between these 2 container.
Now if we dont select the option of 'Shared throughput across container' then each container will have dedicated throughput and it will not be shared across the database containers.
So if we set both containers A and B as autoscale individually then there will be no impact of them on each other.
Individual Container in Separate Database ("Container A" in "Database 1" and "Container B" in "Database 2")
This will behave as if we are not selecting 'Shared throughput across container' option and all containers will have their dedicated throughput.
Please let us know if this helps or else we can discuss more on this.
----------
If answer is helpful please please click on
as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions. Thank you for helping to improve Microsoft Q&A!