Space management

Prerequisites

• This feature is not supported for ApsaraDB RDS for SQL Server 2008 R2 instances that use cloud disks.

• The instance must be in one of the following regions:

  Public Cloud: China (Hangzhou), China (Shanghai), China (Qingdao), China (Beijing), China (Zhangjiakou), China (Hohhot), China (Ulanqab), China (Shenzhen), China (Heyuan), China (Guangzhou), China (Chengdu), China (Hong Kong), Singapore, and UAE (Dubai).

  Financial Cloud: China (Hangzhou) Finance, China (Shanghai) Finance, China (Shenzhen) Finance, and China (Beijing) Finance.

  Government Cloud: China (Beijing) Gov Cloud 1.

Procedure

1. Log on to the DAS console.

2. In the navigation pane on the left, click Intelligent O&M Center > Instance Monitoring .

3. Find the target instance and click the instance ID to open the instance details page.

4. In the navigation pane on the left, click Space Management. You can then view the following information:

   • Storage Overview: Provides a high-level view of your instance's storage, including weekly changes, available storage, used storage, and growth estimates. The following table describes the parameters.

     Parameter	Description
     Changes in the Last Week	The change in the instance's storage over the past week and its average daily growth. Note The average daily growth is calculated from the time the instance was created to the present. A negative value indicates a decrease in storage.
     Available Storage	The remaining available storage and the estimated number of days it will last.
     Used Storage	The instance's used storage and the number of days it has been in use.
     Estimated to reach	The predicted number of days until the instance's storage usage reaches 80% and 100%, based on current usage patterns.
     Data Updated At	The time when the data on the Space Management page was last updated.
     Recollect	If the Data Updated At timestamp is outdated, click Recollect. The system then recollects the data asynchronously. Note The data is recollected asynchronously. Wait a few minutes and then refresh the page to view the latest results.
     Save as PDF File	Click Save as PDF File to save the page as a PDF.

   • Charts of Storage Information: Displays charts of the instance's storage, including storage usage, data-to-log ratio, and the top 5 databases by size. The following table describes the parameters.

     Parameter	Description
     Storage Usage	Displays the instance's current storage usage rate in a gauge chart. If the storage usage exceeds 80%, you should consider expanding the storage or cleaning up data. For more information about storage expansion, see automatic storage expansion or change specifications.
     Data to Log Ratio	Displays the ratio of data storage to log storage as a pie chart. If the log storage proportion is too high, you may need to shrink the log in the console or enable the 30-minute log backup feature.
     Top 5 Database Storage Spaces	Displays the storage details for the top 5 databases by storage usage in a horizontal bar chart, including: Total space (MB) Data space (MB) Log space (MB)

     

   • Storage Trend: Displays the instance's storage change history as a line chart. You can view graphs for the last day, week, or month, including the instance's total storage, data storage, and log storage.

     

   • Top 10 Databases: Displays detailed information in a table for the top 10 databases by storage consumption. The following table describes the parameters.

     Parameter	Description
     Database Name	The name of the database within the instance.
     Status	The status of the database.
     Total Space (MB)	The total space occupied by the database, in MB.
     Used Storage (MB)	The used space of the database (in MB) and its percentage of the database's total space.
     Available Storage (MB)	The remaining available space in the database (in MB) and its percentage of the database's total space.
     Recovery Mode	The recovery model of the database. Note For non-system databases, this is typically FULL.
     Sorting Rule	The character set collation for the database.
     Log Reuse Wait	A description of the event that the database log is waiting on before it can be reused.
     Created At	The time the database was created.
     System Database	Indicates whether the database is a SQL Server system database.

     Click the + icon in the leftmost column of a row to expand it and view details about the database's files. The following table describes the parameters.

     Parameter	Description
     Database Name	The name of the database.
     File Group	The name of the filegroup where the file is located. Note Log files do not belong to a filegroup, so this field is empty for log files.
     File Type	The type of the file, typically Data or Log.
     File Name	The name of the file within the database.
     Total Storage (MB)	The total space of the file, in MB.
     Used Storage (MB)	The used space of the file (in MB) and its percentage of the total.
     Available Storage (MB)	The available space for the file (in MB) and its percentage of the total.
     Maximum File Size	The size limit of the database file, in MB. Note A value of 0 indicates no limit.
     Automatic File Growth	The increment by which the database file grows automatically, which is typically a percentage or a fixed value.

   • Top 20 Data Tables: Displays information in a table for the top 20 tables by storage consumption. The following table describes the parameters.

     Parameter	Description
     Table Name	Consists of three parts: database name schema name object name
     Size (MB)	The total space occupied by the table, in MB.
     Data Storage (MB)	The space occupied by data in the table (in MB) and its percentage of the reserved size.
     Index Storage (MB)	The space occupied by indexes on the table (in MB) and its percentage of the reserved size.
     Unused Storage (MB)	The unused space within the table's allocation (in MB) and its percentage of the reserved size.
     Rows	The number of rows in the table.
     Index Quantity	The number of indexes on the table.
     Created At	The time the table was created.