Storage Analysis

Scenarios

RDS for SQL Server monitors and analyzes storage of instances, databases, and tables, so that you can quickly detect and locate storage issues based on the storage overview.

Constraints

To use the storage analysis function, contact the customer service.

Checking the Storage Overview

1. Log in to the Huawei Cloud console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner, and under Databases, click Data Admin Service.
4. In the navigation pane, choose Intelligent O&M > Instance List.

   Alternatively, on the Overview page, click Go to Intelligent O&M.

5. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
6. Locate the target instance and click Details.
7. Click the Storage Analysis tab and check information in the Overview area.
   • The following information is displayed:
     • Storage usage
     • Available storage
     • Average daily increase in the last week
     • Disk space distribution
       

       • Data space: disk space occupied by user data
       • OpLog: disk space for storing oplogs
       • Other: disk space for storing metadata and temporary files generated by databases and the OS
   • If you are running out of storage, click Scale in the upper right corner.

Viewing the Disk Space Change Trend

You can view the disk space change trend.

Top 20 Databases

You can view details about the top 20 databases by physical file size, including file information.

• Click View Chart in the Operation column to view storage changes in the last 7 days, last 30 days, or a custom time period within 30 days.
• Click next to a database to expand its files.

  Table 2 File list parameters

  Parameter	Description
  File Group	Name of the file group where the file is located. The file group of log files is NULL.
  File Type	Type of the file, which can be Data, Log, or Filestream.
  File Name	Name of the file.
  Total (MB)	Total space of the file, in MB.
  Used space (MB)	Used space of the file, in MB.
  Available (MB)	Available space of the file, in MB.
  Max. File Size (MB)	Maximum file space, in MB. The value -1 indicates that the file space is not limited.
  Automatic File Growth	Automatic growth of the file, in MB or percentage.
  Operation	Shrink files.

  In the database file list, select one or more files and click Shrink Files to clear redundant data fragments in the files.