This topic describes how to view the performance statistics of an ApsaraDB RDS for SQL Server instance by using CloudDBA in the ApsaraDB RDS console. CloudDBA allows you to query the performance statistics over a specific time range, view the performance statistics in histograms, and update the performance statistics. You can identify and resolve the performance issues of the RDS instance based on the performance statistics to ensure the high performance of the instance.

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 > Performance Optimization.
  3. Click the Statistics tab.

Introduction to the Statistics tab

  • Statistics Overview: This section provides an overview of the performance statistics of the RDS instance. The following table describes the parameters in the Statistics Overview section.
    Table 1. Parameters in the Statistics Overview section
    Parameter Description
    Total Statistics The total number of statistical items that are collected from the RDS instance.
    Not Updated for More Than 7 Days The number of statistical items that are not updated for more than seven days in the RDS instance.
    Not Updated for More Than 14 Days The number of statistical items that are not updated for more than 14 days in the RDS instance.
    Not Updated for More Than 30 Days The number of statistical items that are not updated for more than 30 days in the RDS instance.
    Data Updated At The time at which the performance statistics of the RDS instance were generated.
    Recollect Data If the performance statistics are outdated, click Recollect Data. In the message that appears, click OK. ApsaraDB RDS starts to collect the performance statistics of the RDS instance again.
    Note After a few minutes, you can refresh the Performance Optimization page to view the updated performance statistics.
    Save as PDF File If you want to save the performance statistics of the RDS instance to your computer as a file, click Save as PDF File.
  • Statistics Not Updated: This section uses charts to display the number of statistical items that are not updated in the RDS instance. The following table describes the parameters in the Statistics Not Updated section.
    Table 2. Parameters in the Statistics Not Updated section
    Parameter Description
    Statistics Not Updated This column chart displays the numbers of the statistical items that are not updated for more than 1 day, 7 days, 14 days, and 30 days.
    Statistics Not Updated in Percentages This pie chart shows the percentages of the statistical items that are not updated for more than 1 day, 7 days, 14 days, and 30 days.
  • Statistics table: This table displays the details about all statistical items that are collected from the RDS instance. The following table describes the parameters for a statistical item in the statistics table.
    Table 3. Parameters in the statistics table
    Parameter Description
    Table Name The name of the table from which the statistical item is collected. The value of this parameter consists of the following three parts:
    • Database name
    • Schema name
    • Object name
    Statistics Name The name of the statistical item.
    Column Name The name of the column from which the statistical item is collected.
    Last Update Time. The most recent time at which the statistical item was updated. If the statistical item is not updated for more than 14 days, we recommend that you manually update the statistical item.
    Actions Includes two operations: Obtain Histogram and Update.
    • Obtain Histogram: You can click Obtain Histogram in the Actions column to view the distribution of the statistics about the statistical item.
    • Update: You can click Update in the Actions column to view the updated statistics about the statistical item.

    The following conclusions can be made from the histogram that is shown in the preceding figure:

    The statistics about the IX_SalesOrderHeader_SalesPersonID index, which is created on the SalesPersonID columnof the testdb4.Sales.SalesOrderHeader table, are unevenly distributed. The value of the AVG_RANG_ROWS metric of the index abruptly increases and decreases possibly due to data skew issues. You must update the statistics about the index. To do so, you need only to click Update in the Actions column of the index.