Database Autonomy Service (DAS) provides a storage management feature that monitors storage consumption at three levels: instance, database, and table. Use this feature to track storage trends, identify the top consumers, and act before storage runs out.
Prerequisites
Before you begin, ensure that:
Your RDS instance does not run SQL Server 2008 R2 with cloud disks
View storage information
Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region where your instance resides. Find the instance and click its ID.
In the left-side navigation pane, choose Autonomy Services > Storage Management.
The Storage Management page contains the following sections.
Storage overview
The Storage Overview section provides a snapshot of instance-level storage health, including how fast storage is being consumed and when it is projected to run out.
| Parameter | Description |
|---|---|
| Changes in the last week | The net storage change over the past seven days, plus the average daily growth since the instance was created. A negative value means storage consumption decreased. |
| Available storage | The amount of free storage remaining and the number of days for which the storage remains available on your RDS instance. |
| Used storage | The amount of storage currently in use and the number of days for which the storage is used on your RDS instance. |
| Estimated to reach | The estimated number of days until storage usage reaches 80% and 100%, based on historical consumption. |
| Data updated at | The timestamp of the most recent storage data collection. |
| Recollect | Click Recollect to trigger a fresh data collection, then click OK in the confirmation dialog. Refresh the Storage Management page after a few minutes to see the updated data. |
| Save as PDF file | Click to save the index usage statistics of the RDS instance to your computer as a PDF file. |
Charts of storage information
The Charts of Storage Information section visualizes storage consumption at the instance level across three charts.
| Chart | Description |
|---|---|
| Storage usage | A gauge chart showing the current storage usage percentage. If usage exceeds 80%, expand the instance's storage capacity or delete data that is no longer needed. For details, see Change the specifications of an ApsaraDB RDS instance. |
| Data and log percentage | A pie chart showing the split between used data storage and used log storage. If the log storage percentage is abnormally high, compress logs or enable the 30-minute log backup feature. For details, see Back up the data of an ApsaraDB RDS instance. |
| Top 5 database storage spaces | A column chart showing storage consumed by the five highest-consuming databases. Each database entry shows total storage, data storage, and log storage in MB. |
Storage trend
The Storage Trend section displays a line chart of storage consumption over the last day, last week, or last month. The chart tracks total storage, data storage, and log storage separately.
Top 10 databases
The Top 10 Databases section lists the ten databases consuming the most storage, along with detailed metadata for each.
| Parameter | Description |
|---|---|
| Database name | The name of the database. |
| Status | The current status of the database. |
| Total space (MB) | The total storage allocated to the database. |
| Used storage (MB) | The storage used by the database and its percentage of total storage for the database. |
| Available storage (MB) | The free storage available to the database and its percentage of the total storage space for the database. |
| Restore mode | The recovery model used by the database. Non-system databases typically use the FULL recovery model. |
| Sorting rule | The collation used by the database. |
| Log reuse wait | The reason the database log is waiting to be reused. |
| Created at | The time the database was created. |
| System database | Indicates whether the database is a system database. |
File-level details
To view the top 10 files consuming the most storage within a database, click the plus sign (+) to the left of the database row.
| Parameter | Description |
|---|---|
| Database name | The name of the database to which the file belongs. |
| File group | The file group the file belongs to. Log files do not belong to a file group, so this field is blank for log files. |
| File type | The type of the file. Valid values: Data and Log. |
| File name | The name of the file. |
| Total storage (MB) | The total storage allocated to the file. |
| Used storage (MB) | The storage used by the file and its percentage of total storage for the file. |
| Available storage (MB) | The free storage available to the file and its percentage of the total storage space for the file. |
| Maximum file size | The maximum size the file can grow to, in MB. A value of 0 means the file size is unlimited. |
| Automatic file growth | The increment by which storage allocated to the file grows automatically, expressed as a percentage or a fixed size. |
Top 20 data tables
The Top 20 Data Tables section lists the twenty tables consuming the most storage.
| Parameter | Description |
|---|---|
| Table name | The fully qualified name of the table, in the format: database name, schema name, and object name. |
| Size (MB) | The total storage allocated to the table. |
| Data storage (MB) | The storage used by table data and its percentage of total table storage. |
| Index storage (MB) | The storage used by indexes on the table and its percentage of total table storage. |
| Unused storage (MB) | The free storage available to the table and its percentage of total table storage. |
| Rows | The total number of rows in the table. |
| Index quantity | The number of indexes on the table. |
| Created at | The time the table was created. |