This topic describes how to view the storage information of an ApsaraDB RDS for SQL Server instance by using CloudDBA. CloudDBA provides the storage management feature. This feature allows you to monitor and analyze your storage consumption at three levels: instance, database, and table. You can 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.

Procedure

  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the left-side navigation pane, choose CloudDBA > Storage Management. Then, you can view the following sections:
    • Basic information: This section displays the basic information about your RDS instance. The basic information includes the ID, edition, and start time of your RDS instance. The following table describes the parameters in the basic information section.
      Table 1. Parameters in the basic information section
      Parameter Description
      Instance ID The unique identifier of your RDS instance.
      Edition The SQL Server major version, edition, minor version, and patch number of your RDS instance. These four parts are separated by hyphens (-).
      Start Time The last time when your RDS instance was started.
    • Storage Overview: This section provides an overview of the overall storage information about your RDS instance. The storage overview includes the storage space changes over the last week, the amount of available storage space, the amount of used storage space, and the estimated increase in storage consumption. The following table describes the parameters in the Storage Overview section.
      Table 2. Parameters in the Storage Overview section
      Parameter Description
      Changes in the Last Week The storage space change and average daily storage consumption increase of your RDS instance over the last week.
      Note A negative value indicates a decrease in storage consumption.
      Available Storage The amount of storage space that is available and the number of days for which the storage space remains available on your RDS instance.
      Used Storage The amount of storage space that is used and the number of days for which the storage space 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 Data If the storage information is outdated, click Recollect Data. In the message that appears, click OK. Then, ApsaraDB RDS starts to collect the storage information again.
      Note After a few minutes, you can refresh the Storage Management page to view the new storage 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 space and used log storage space, and the top 5 databases that consume the most storage space. The following table describes the parameters in the Charts of Storage Information section.
      Table 3. Parameters in the Charts of Storage Information section
      Parameter Description
      Storage Usage The storage usage of your RDS instance. ApsaraDB RDS displays the storage usage in a dashboard. If the storage usage exceeds 80%, you can 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 and Log Percentage The percentage of the used data storage space and the percentage of the used log storage space in your RDS instance. ApsaraDB RDS displays the percentages in a pie chart. If the percentage of the used log storage space is abnormally high, you may need to 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 space that is used by each of the top 5 databases that consume the most storage space. ApsaraDB RDS displays the following information about the used storage space 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 space, the data storage space, and the log storage space.
      Note This feature is new. It cannot be used to collect the storage information that was generated before this feature is released.
    • Top 10 Databases: This section displays the details about the top 10 databases that consume the most storage space. These details are displayed in a table. The following table describes the parameters in the Top 10 Databases section.
      Table 4. Parameters in the Top 10 Databases section
      Parameter Description
      Database Name The name of the database.
      Status The status of the database.
      Total Storage (MB) The total amount of storage space that is allocated to the database.
      Used Storage (MB) The amount of storage space that is used by the database and the percentage of the used storage space in the total storage space for the database.
      Available Storage (MB) The amount of storage space that is available to the database and the percentage of the available storage space in the total storage space for the database.
      Restoration 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.
      Collation The character set collation that is used for the database.
      Log Reuse Wait The description of the Log Reuse Wait event in the database.
      Creation Time The time when the database was created.
      System Database Indicates 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 top 10 files that consume the most storage space in the database. The following table describes the parameters of the top 10 files in a database.

      Table 5. Parameters of the top 10 files
      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 space that is allocated to the file.
      Used Storage (MB) The amount of storage space that is used by the file and the percentage of the used storage space in the total storage space for the file.
      Available Storage (MB) The amount of storage space that is available to the file and the percentage of the available storage space in the total storage space 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 space 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 space. These details are displayed in a table. The following table describes the parameters in the Top 20 Data Tables section.
      Table 6. 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 three parts:
      • Database name
      • Schema name
      • Object name
      Retained Size (MB) The total amount of storage space that is allocated to the data table.
      Data Storage (MB) The amount of storage space that is used by the data in the data table and the percentage of the used storage space in the total storage space for the data table.
      Index Storage (MB) The amount of storage space that is used by the indexes on the data table and the percentage of the used storage space in the total storage space for the data table.
      Unused Storage (MB) The amount of storage space that is available to the data table and the percentage of the available storage space in the total storage space for the data table.
      Rows The total number of rows in the data table.
      Indexes The number of indexes in the data table.
      Creation Time The time when the data table was created.