All Products
Search
Document Center

ApsaraDB RDS:View the performance statistics of an ApsaraDB RDS for SQL Server instance

Last Updated:Oct 08, 2023

This topic describes how to view the performance statistics of an ApsaraDB RDS for SQL Server instance by using autonomy services in the ApsaraDB RDS console. Autonomy services allows you to query the performance statistics of an RDS instance, view the performance statistics in histograms, and update the performance statistics at the earliest opportunity. This ensures the high performance of the RDS instance.

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 > Performance Optimization.

  3. Click the Statistics tab.

Overview of 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

    If the performance statistics of the RDS instance are outdated, click Recollect. In the message that appears, click OK. The system 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 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.

    In the example shown in the following figure, none of the statistical items are updated within 30 days. In this case, we recommend that you immediately update the statistical items.

    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 data table. The value of this parameter consists of the following 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

    The operations that can be performed on a statistical item. The operations include 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 UQ__students__DDDFDD3782789355 index, which is created on the SalesPersonID column of the testdb01.dbo.students table, are unevenly distributed. The value of the Avg_RangeRows metric of the index may abruptly increase and decrease due to data skew issues. In this case, you must update the performance statistics of the RDS instance. To update the performance statistics of an RDS instance, you need only to click Update in the Actions column of the statistical item.