The autonomy service provides the TOP Objects query feature to display performance issues at the object level (stored procedures, functions, triggers, etc.) in RDS user instances.
Prerequisites
Your RDS instance does not run SQL Server 2008 R2 with cloud disks.
Your RDS instance resides in one of the following regions: China (Hangzhou), China (Shanghai), China (Qingdao), China (Beijing), China (Zhangjiakou), China (Hohhot), China (Ulanqab), China (Shenzhen), China (Heyuan), China (Guangzhou), China (Chengdu), China (Hong Kong), Singapore, and UAE (Dubai)..
Procedure
Log on to the ApsaraDB RDS console and 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 instance ID.
In the navigation pane on the left, choose .
Click the TOP Objects tab.
In the right side of the page, select the database name, refresh interval, sorting method, number of entries to display, and turn on the Automatic Refresh switch.
Page overview
Top Object Overview: This section displays the last update time of the object information and lets you control the data displayed on the entire page. The following table describes the parameters in this section.
Table 1. Parameters in the TOP Object Overview section
Parameter
Description
DB Filter
The database whose objects you want to view. You can select more than one database to view multiple databases simultaneously.
Auto-Refresh Interval
If automatic refresh is enabled, you can select one of four values for the page refresh interval: 5, 10, 30, and 60 seconds.
Top User Objects By Performance Consumption
The metric based on which the system sorts the objects of the instance in real time. You can sort by Average CPU Overhead, Average Execution Duration, Total CPU Overhead, Total Logical Reads, Total Physical Reads, and other metrics.
TOP XX Entries
The number of top objects you want to view. You can choose from three values: 5, 10, and 15 entries.
Automatic Refresh
Set automatic refresh for real-time TOP Objects information on the page.
Data Updated At
The time when the statistics information page data of the RDS instance was generated.
Save As PDF File
To save the page to your local computer, click Save As PDF File and wait patiently for the PDF file to be generated.
Real-time Top Objects - Average Cost: This section displays the top N objects of your instance based on the following metrics: Average CPU Overhead, Average Execution Duration, Average Logical Reads, and Average Returned Rows. The following table describes the parameters in this section.
Table 2. Parameters in the Real-time Top Objects - Average Cost section
Parameter
Description
Average CPU Overhead
The average CPU overhead per statement execution for each database object. Unit: milliseconds.
Average Execution Duration
The average running time per statement execution for each database object. Unit: milliseconds.
Average Logical Reads
The average number of logical reads per statement execution for each database object.
Average Returned Rows
The average number of rows that are returned per statement execution for each database object.
Real-time Top Objects - Total Cost: This section displays the top N objects of your instance based on the following metrics: Total CPU Overhead Percentage, Total Execution Duration Percentage, Total Logical I/O Percentage, and Total Returned Rows Percentage. The following table describes the parameters in this section.
Table 3. Parameters in the Real-time Top Objects - Total Cost section
Parameter
Description
Total CPU Overhead Percentage
The percentage of the total CPU overhead that is produced by the database object.
Total Execution Duration Percentage
The percentage of the total running time that is required by the database object.
Total Logical I/O Percentage
The percentage of the total logical I/O that is required by the database object.
Total Returned Rows Percentage
The percentage of the total number of rows that are returned by the database object.
Real-time Top Objects - List
This section describes the real-time performance drains for objects in the database of the instance. The following table describes the parameters in this section.
Table 4. Overview of parameters in the Real-time Top Objects - List section
Parameter
Description
Object Name
The name of the database object, including database name, schema name, and object name.
Object Type
The type of the database object, including stored procedure, function, trigger, etc.
Total Executions
The total number of statement executions on the database object after you restart your instance or clear the cache.
Total CPU Overhead
The total CPU overhead for all statement executions on the database object after you restart your instance or clear the cache. Unit: milliseconds.
Average CPU Overhead
The average CPU overhead per statement execution on the database object. Unit: milliseconds.
Total Execution Duration
The total running time of all statement executions on the database object after you restart your instance or clear the cache. Unit: milliseconds.
Average Execution Duration
The average running time per statement execution on the database object. Unit: milliseconds.
Total Returned Rows
The total number of rows that are returned for all statement executions on the database object after you restart your instance or clear the cache.
Average Returned Rows
The average number of rows that are returned per statement execution on the database object.
Total Logical Reads
The total number of logical reads on the database object after you restart your instance or clear the cache.
Average Logical Reads
The average number of logical reads per statement execution on the database object.
Total Physical Reads
The total number of physical reads on the database object after you restart your instance or clear the cache.
Average Physical Reads
The average number of physical reads per statement execution on the database object.
Total Logical Writes
The total number of logical writes on the database object after you restart your instance or clear the cache.
Average Logical Writes
The average number of logical writes per statement execution on the database object.
Total Logical I/O
The total logical I/O for the database object after you restart your instance or clear the cache.
Average Logical I/O
The average logical I/O per statement execution on the database object.
This section also provides details about the performance drain for each SQL statement on an object. To view these details, you can click the plus sign (+) button on the left to see detailed performance consumption at the SQL statement level within the database object. The following table describes the parameters in this section.
Table 5. Detailed parameters in the Real-time Top Objects - List section
Parameter
Description
Object Name
The name of the database object to which the SQL statement belongs, including database name, schema name, and object name.
Statement (View Details)
The details about the SQL statement. You can click to view the complete SQL statement.
Executions
The total number of times that the SQL statement is executed.
Obtain Query Plan
The number of times that the system obtains the execution plan of the SQL statement.
Total CPU Overhead
The total CPU overhead of the SQL statement. Unit: milliseconds.
Average CPU Overhead
The average CPU overhead per execution of the SQL statement. Unit: milliseconds.
Minimum CPU Overhead
The minimum CPU overhead among all executions of the SQL statement. Unit: milliseconds.
Maximum CPU Overhead
The maximum CPU overhead among all executions of the SQL statement. Unit: milliseconds.
Last CPU Overhead
The CPU overhead for the last execution of the SQL statement. Unit: milliseconds.
Total Execution Duration
The total running time of the SQL statement. Unit: milliseconds.
Average Execution Duration
The average running time per execution of the SQL statement. Unit: milliseconds.
Minimum Execution Duration
The minimum running time among all executions of the SQL statement. Unit: milliseconds.
Maximum Execution Duration
The maximum running time among all executions of the SQL statement. Unit: milliseconds.
Last Execution Duration
The running time for the last execution of the SQL statement. Unit: milliseconds.
Total Returned Rows
The total number of rows that are returned for the SQL statement.
Average Returned Rows
The average number of rows that are returned per execution of the SQL statement.
Minimum Returned Rows
The minimum number of rows that are returned among all executions of the SQL statement.
Maximum Returned Rows
The maximum number of rows that are returned among all executions of the SQL statement.
Last Returned Rows
The number of rows that are returned for the last execution of the SQL statement.
Total Logical Reads
The total number of logical reads that are run for the SQL statement.
Average Logical Reads
The average number of logical reads that are run per execution of the SQL statement.
Minimum Logical Reads
The minimum number of logical reads that are run among all executions of the SQL statement.
Maximum Logical Reads
The maximum number of logical reads that are run among all executions of the SQL statement.
Last Logical Reads
The number of logical reads that are run for the last execution of the SQL statement.
Total Physical Reads
The total number of physical reads that are run for the SQL statement.
Average Physical Reads
The average number of physical reads that are run per execution of the SQL statement.
Minimum Physical Reads
The minimum number of physical reads that are run among all executions of the SQL statement.
Maximum Physical Reads
The maximum number of physical reads that are run among all executions of the SQL statement.
Last Physical Read
The number of physical reads that are run for the last execution of the SQL statement.
Total Logical Writes
The total number of logical writes that are run for the SQL statement.
Average Logical Writes
The average number of logical writes that are run per execution of the SQL statement.
Minimum Logical Writes
The minimum number of logical writes that are run among all executions of the SQL statement.
Maximum Logical Writes
The maximum number of logical writes that are run among all executions of the SQL statement.
Last Logical Writes
The total number of logical writes that are run for the SQL statement.
Total Logical I/O
The total logical I/O for the SQL statement.
Average Logical I/O
The average logical I/O per execution for the SQL statement.
Minimum Logical I/O
The minimum logical I/O among all executions of the SQL statement.
Maximum Logical I/O
The maximum logical I/O among all executions of the SQL statement.
Last Logical I/O
The logical I/O for the last execution of the SQL statement.
Last Execution Duration
The running time for the last execution of the SQL statement.