All Products
Search
Document Center

ApsaraDB RDS:View the storage information of an ApsaraDB RDS for SQL Server instance

Last Updated:Oct 08, 2023

This topic describes how to view the storage information of an ApsaraDB RDS for SQL Server instance. Database Autonomy Services (DAS) provides the storage management feature that allows you to monitor and analyze your storage consumption at three levels: instance, database, and table. This feature enables you to identify and troubleshoot storage issues based on the storage monitoring and analysis data.

The storage management feature provides the basic information, storage overview, storage details, and storage trends of your RDS instance from various dimensions.

Prerequisites

Your RDS instance does not run SQL Server 2008 R2 with cloud disks.

Procedure

  1. 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.
  2. In the left-side navigation pane, choose Autonomy Services > Storage Management. Then, you can view the following sections:

    • Storage Overview: This section provides an overview of the storage information about your RDS instance. The storage information includes Changes in the Last Week, Available Storage, Used Storage, and Estimated to Reach. The following table describes the parameters in the Storage Overview section.

      Table 1. Parameters in the Storage Overview section

      Parameter

      Description

      Changes in the Last Week

      The storage change over the last week and the average growth of storage consumption of your RDS instance.

      Note
      • The average growth of storage consumption indicates the average daily growth of storage consumption from the time when your RDS instance is created to the current time.

      • If the value is negative, the storage consumption is reduced.

      Available Storage

      The amount of available storage and the number of days for which the storage remains available on your RDS instance.

      Used Storage

      The amount of used storage and the number of days for which the storage is used on your RDS instance.

      Estimated to Reach

      The estimated number of days for the storage usage of your RDS instance to reach 80% and 100%. The estimate is based on your storage consumption history.

      Data Updated At

      The time when the storage information of your RDS instance was generated.

      Recollect

      If the storage information is outdated, click Recollect. In the message that appears, click OK. The system starts to collect the storage information again.

      Note

      After a few minutes, you can refresh the Space Management page to view the updated information.

      Save as PDF File

      If you want to save the storage information to your computer as a file, click Save as PDF File.

    • Charts of Storage Information: This section displays the information about the storage consumption of your RDS instance in charts. The storage consumption information includes the storage usage, the percentages of used data storage and used log storage, and the top 5 databases that consume the most storage. The following table describes the parameters in the Charts of Storage Information section.

      Table 2. Parameters in the Charts of Storage Information section

      Parameter

      Description

      Storage Usage

      The storage usage of your RDS instance. The system displays the storage usage in a dashboard. If the storage usage exceeds 80%, we recommend that you expand the storage capacity of your RDS instance or delete the data that is no longer required. For more information, see Change the specifications of an ApsaraDB RDS instance.

      Data to Log Ratio

      The percentage of the used data storage and the percentage of the used log storage in your RDS instance. The system displays the percentages in a pie chart. If the percentage of the used log storage is abnormally high, we recommend that you compress logs or enable the 30-minute log backup feature in the ApsaraDB RDS console. For more information, see Back up the data of an ApsaraDB RDS instance.

      Top 5 Database Storage Spaces

      The amount of storage used by each of the top 5 databases that consume the most storage. ApsaraDB RDS displays the following information about the used storage in a column chart:

      • Total Storage (Unit: MB)

      • Data Storage (Unit: MB)

      • Log Storage (Unit: MB)

    • Storage Trend

      This section displays the storage trends of your RDS instance over the last day, the last week, or the last month in a line chart. The storage information includes the total storage, the data storage, and the log storage.

    • Top 10 Databases: This section displays the details about the top 10 databases that consume the most storage. These details are displayed in a table. The following table describes the parameters in the Top 10 Databases section.

      Table 3. Parameters in the Top 10 Databases section

      Parameter

      Description

      Database Name

      The name of the database.

      Status

      The status of the database.

      Total Space (MB)

      The total amount of storage that is allocated to the database.

      Used Storage (MB)

      The amount of storage that is used by the database and the percentage of the used storage in the total storage for the database.

      Available Storage (MB)

      The amount of storage that is available to the database and the percentage of the available storage in the total storage for the database.

      Recovery Mode

      The mode that is used to restore the database.

      Note

      In most cases, if the database is not a system database, the FULL recovery model is used.

      Sorting Rule

      The character set collation that is used for the database.

      Log Reuse Wait

      The description of the Log Reuse Wait event in the database.

      Created At

      The time when the database was created.

      System Database

      Specifies whether the database is a system database.

      You can find a database and click the plus sign (+) on the left to view the details about the files in the database. The following table describes the parameters of a file in a database.

      Table 4. Top 10 parameters of a file in a database

      Parameter

      Description

      Database Name

      The name of the database to which the file belongs.

      File Group

      The name of the file group to which the file belongs.

      Note

      If the file is a log file, it does not belong to a file group. In this case, this parameter is empty.

      File Type

      The type of the file. Valid values: Data and Log.

      File Name

      The name of the file.

      Total Storage (MB)

      The total amount of storage that is allocated to the file.

      Used Storage (MB)

      The amount of storage that is used by the file and the percentage of the used storage in the total storage for the file.

      Available Storage (MB)

      The amount of storage that is available to the file and the percentage of the available storage in the total storage for the file.

      Maximum File Size

      The maximum size of the file. Unit: MB.

      Note

      The value 0 indicates that the size of the file is not limited.

      Automatic File Growth

      The increment at which the storage that is allocated to the file increases. In most cases, the storage increases based on a percentage or a fixed size.

    • Top 20 Data Tables: This section displays details about the top 20 data tables that consume the most storage. These details are displayed in a table. The following table describes the parameters in the Top 20 Data Tables section.

      Table 5. Parameters in the Top 20 Data Tables section

      Parameter

      Description

      Table Name

      The name of the data table. The value of this parameter consists of the following parts:

      • Database name

      • Schema name

      • Object name

      Size (MB)

      The total amount of storage that is allocated to the data table.

      Data Storage (MB)

      The amount of storage that is used by the data table and the percentage of the used storage in the total storage for the data table.

      Index Storage (MB)

      The amount of storage that is used by the indexes on the data table and the percentage of the used storage in the total storage for the data table.

      Unused Storage (MB)

      The amount of storage that is available to the data table and the percentage of the available storage in the total storage for the data table.

      Rows

      The total number of rows in the data table.

      Index Quantity

      The number of indexes in the data table.

      Created At

      The time when the metatable was created.