ApsaraDB RDS for SQL Server supports automatic storage expansion. If the storage usage of an instance reaches a preset threshold, the system automatically expands the storage capacity. This feature improves application availability and performance and reduces management overhead.
Background information
For more information, see Auto Scaling.
Prerequisites
The RDS instance meets the following requirements:
Storage type: enterprise SSD (ESSD)
Instance edition: High-availability Edition or Cluster Edition
Status: Running
Billing method: subscription or pay-as-you-go. Serverless ApsaraDB RDS for SQL Server instances are not supported.
NoteIf a Serverless instance has insufficient storage, you can manually expand the storage capacity.
Automatic storage expansion cannot be configured separately for SQL Server read-only instances.
Your account has a sufficient balance to cover the expansion costs.
Usage notes
If a primary instance has read-only instances and triggers an automatic storage expansion, the system checks the storage size of each read-only instance. If a read-only instance has less storage than the target size of the primary instance, the system expands the storage of the read-only instance first. After the storage of all applicable read-only instances is expanded, the system expands the storage of the primary instance.
Some instances cannot use this feature because of Windows driver limitations. In this case, update the minor engine version.
Automatic scale-in is not supported after an automatic storage expansion.
Billing
The billing rules are the same as those for manually expanding the storage capacity of an RDS instance. For more information, see Billing of specification changes.
Procedure
Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the Instance Resources section, click Settings to the right of Automatic Storage Expansion.
Configure the following parameters and click OK.
Category
Description
Automatic Storage Expansion
Specifies whether to enable automatic storage expansion.
Available Storage ≤
When the percentage of remaining free space reaches the specified value, an automatic expansion is triggered.
NoteThe expanded storage size is the greater of the following two values:
5 GB. If the total storage space of the instance is less than 50 GB and the free space is less than 10%, the scaling step size is adjusted to 10 GB.
15% of the current instance storage space. The result is rounded to the nearest multiple of 5.
Maximum Storage Capacity:
The upper limit for automatic expansion. The value must be greater than or equal to the current total storage space of the instance.
enterprise SSD (ESSD) upper limit: 32000 GB
Standard SSD upper limit: 6000 GB
View expansion history
Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the Instance Resources section, click Storage Expansion Records to the right of Automatic Storage Expansion to go to the Database Autonomy Service console.
On the Autonomy Center page, set Type to Auto-Scaling Events to view the history of triggered storage expansions.

Click Details for the target Auto Scaling event to view the expansion details.

References
In addition to the automatic storage expansion feature described in this topic, you can also manually increase the storage space of an instance. For more information, see Expand the storage space of a non-Serverless instance or Expand the storage space of a Serverless instance.
For more information about issues and solutions related to insufficient storage space for ApsaraDB RDS for SQL Server, see Insufficient storage space for ApsaraDB RDS for SQL Server.
Related APIs
API | Description |
Configure automatic storage expansion for a non-Serverless instance. |