I have a container that contains less than 5 GB of data. From what I have read, a 5 GB container could reside on a single physical partition. However, this container is currently split across 4 physical partitions (shown as "partition key ranges" in "Metrics"). This has a negative impact on performance as throughput is split evenly between the physical partitions.
The container evolved as follows:
The initially empty container was created with 20,000 RU/s.
Approx. 5 GB of data was created in the container.
The throughput was decreased to 400 RU/s.
The throughput was manually changed multiple times between 10,000 RU/s and the current final value of 400 RU/s.
Which of the steps above caused the container to be split across 4 physical partitions?
If I had created the container with 10,000 RU/s initially, and made sure that the manually provisioned throughput subsequently only fluctuated between 400 and 10,000 RU/s, would the container have stayed on a single physical partition?
Is there a way to "defragment" the container (apart from recreating it) so it gets stored on the minimum number of physical partitions actually required?