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 DAS console.
2. Click in the upper left corner and select a region and project.
3. In the navigation pane, choose Intelligent O&M > Instance List.

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

4. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
5. Locate the target instance and click Details.
6. Click the Storage Analysis tab and check information in the Overview area. If the capacity is insufficient, scale up the storage in a timely manner.
   Figure 1 Overview
   

   Table 1 Space overview parameters

   Parameter	Description
   Storage Usage	Storage usage of an instance
   Available	Available storage of an instance
   Available days of storage	Estimated days that remaining storage can be used
   Avg. daily increase in last week	Average daily increase in storage usage in the last seven days
   Used Storage	Storage distribution. For details, see Table 2.

   Table 2 Storage distribution parameters

   Parameter	Description
   Data	Total space occupied by data files
   Transaction logs	Total space occupied by transaction logs
   Run logs	Total space occupied by run logs
   Slow query logs	Total space occupied by slow query logs
   Audit logs	Total space occupied by audit logs
   Temporary space	Total space of the tempdb database
   System database	Total space of the msdb database

Viewing the Disk Space Change Trend

You can view the disk space change trend.

Figure 2 Used Storage over Time

Top 20 Databases

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

Figure 3 Database information

• You can click View Chart in the database list to view database space changes in the last 7 days, last 30 days, or a custom period.
  Figure 4 Database data trend
  
• You can click next to a database to expand files contained in the database.

  Table 4 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	File type. The value can be Data, Log, or Filestream.
  File Name	Database file name
  Total (MB)	Total space occupied by files, in MB
  Used space (MB)	Used file space, in MB
  Available (MB)	Available file space, in MB
  Max. File Size (MB)	Maximum file space, in MB. -1 indicates that the file space is not limited.
  Automatic File Growth	Automatic file growth step, in MB or percentage

  In the file list, you can select one or more files and click Shrink Files to shrink the files. This operation is not allowed for the master, msdb, model, and rdsadmin databases.

  Figure 5 Shrink Files
  

Top 20 Tables

You can view details about the top 20 tables by physical file size. Tables whose names contain non-English character sets cannot be displayed.

You can click View Chart in the table list to view tablespace changes in the last 7 days, last 30 days, or a custom period.