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
- 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.
In the left-side navigation pane, choose .
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.
NoteAfter 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.