TOP Objects

Prerequisites

• This feature is not available for ApsaraDB RDS for SQL Server 2008 R2 instances that use cloud disks.

• Your ApsaraDB RDS instance must be 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, or UAE (Dubai).

Procedure

1. 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.

2. In the left-side navigation pane, choose Autonomy Services > Performance Optimization.

3. Click the TOP Objects tab.

4. On the right side of the page, select a database name, refresh interval, sort metric, the number of items to display, and enable Auto Refresh. After you enter the Real-time TOP Objects - Average Overhead page, you can use the toolbar to configure filter settings: Set the Refresh Interval (such as every 10 seconds), click Get to load the data, select a sort metric (such as Average CPU Overhead (ms)), and set the number of items to display (such as Top 10). You can also use the DB Filter drop-down list to filter databases, enable Automatic Refresh, or click Save As PDF File to export the report.

Page overview

• Top objects overview: This section contains page-level controls and shows when the data was last updated. The following table describes the parameters.

  Table 1. Top objects overview parameters

  Parameter	Description
  Database:	Select one or more databases to view.
  Refresh interval	If Automatic Refresh is enabled, this setting determines the refresh frequency. Options are 5, 10, 30, and 60 seconds.
  Sort metric	The metric used to rank the objects in the list. You can sort by metrics such as Average CPU Overhead, Average Execution Duration, Total CPU Overhead, total logical reads, and total physical reads.
  Items to display	The number of top objects to display. Options are 5, 10, and 15.
  Auto Refresh	Enables automatic, real-time data updates on the page.
  Data Updated At	The timestamp of the latest statistics for the RDS instance.
  Save as PDF File	If you need to save the page locally, click Save as PDF File and wait for the PDF file to be generated.

• Real-time top objects - average cost: This section ranks objects by their average per-execution cost. Use this view to identify objects that consume the most resources per execution, regardless of how often they run. The following table describes the parameters.

  Table 2. Real-time top objects - average cost parameters

  Parameter	Description
  Average CPU Overhead	The average CPU overhead per execution of the database object, in milliseconds.
  Average Execution Duration	The average execution duration per execution of the database object, in milliseconds.
  Average Logical Reads	The average number of logical reads per execution of the database object.
  Average Returned Rows	The average number of rows returned per execution of the database object.

• Real-time top objects - total cost: This section ranks objects by their contribution to the instance's total resource consumption. Use this view to identify objects that contribute most to the overall instance load. The following table describes the parameters.

  Table 3. Real-time top objects - total cost parameters

  Parameter	Description
  Total CPU Overhead in Percentage	The database object's share of the instance's total CPU consumption.
  Total Execution Duration in Percentage	The database object's share of the instance's total execution time.
  Total Logical I/O in Percentage	The database object's share of the instance's total logical I/O.
  Total Returned Rows in Percentage	The database object's share of the instance's total returned rows.

• Real-time top objects - list

  • Top objects list overview: This section provides a detailed list of top-consuming objects with their cumulative performance statistics.
    Note: Cumulative statistics such as Total Executions and Total CPU Overhead are measured since the instance was last restarted or its cache was last cleared.
    

    Table 4. Top objects list overview parameters

    Parameter	Description
    Object Name	The name of the database object, which includes the database name, schema name, and object name.
    Object Type	The type of database object, such as stored procedure, function, or trigger.
    Total Executions	The total number of times the object has been executed.
    Total CPU Overhead	The total CPU overhead for the object, in milliseconds.
    Average CPU Overhead	The average CPU overhead per execution for the object, in milliseconds.
    Total Execution Duration	The total execution duration for the object, in milliseconds.
    Average Execution Duration	The average execution duration per execution for the object, in milliseconds.
    Total Returned Rows	The total number of rows returned by the object.
    Average Returned Rows	The average number of rows returned per execution.
    Total Logical Read Count	The total number of logical reads for the object.
    Average Logical Reads	The average number of logical reads per execution.
    Total Physical Read Count	The total number of physical reads for the object.
    Average Physical Reads	The average number of physical reads per execution.
    Total Logical Writes	The total number of logical writes for the object.
    Average Logical Writes	The average number of logical writes per execution.
    Total Logical I/O	The total logical I/O for the object.
    Average Logical I/O	The average logical I/O per execution.

  • Top objects list details: To analyze the performance of individual SQL statements within an object, click the plus icon (+) next to the object's row. The view expands to show detailed metrics for each statement. The following table describes the parameters.

    Table 5. Top objects list details parameters

    Parameter	Description
    Object Name	The parent object of the SQL statement.
    Statement (Click to View Details)	The SQL statement. Click to view the full text of the statement.
    Executed Times	The total number of times the SQL statement was executed.
    Obtain Execution Plans	The number of times the execution plan for the SQL statement was fetched.
    Total CPU Time	The total CPU time consumed by the SQL statement, in milliseconds.
    Average CPU Time	The average CPU time per execution for the SQL statement, in milliseconds.
    Minimum CPU Time	The minimum CPU time for a single execution of the SQL statement, in milliseconds.
    Maximum CPU Time	The maximum CPU time for a single execution of the SQL statement, in milliseconds.
    Last CPU Time	The CPU time of the last execution of the SQL statement, in milliseconds.
    Total Execution Duration	The total execution duration for the SQL statement, in milliseconds.
    Average Execution Duration	The average execution duration per execution for the SQL statement, in milliseconds.
    Minimum Execution Duration	The minimum execution duration for a single execution of the SQL statement, in milliseconds.
    Maximum Execution Duration	The maximum execution duration for a single execution of the SQL statement, in milliseconds.
    Last Execution Duration	The execution duration of the last execution of the SQL statement, in milliseconds.
    Total Returned Rows	The total number of rows returned by the SQL statement.
    Average Returned Rows	The average number of rows returned per execution of the SQL statement.
    Minimum Returned Rows	The minimum number of rows returned in a single execution of the SQL statement.
    Maximum Returned Rows	The maximum number of rows returned in a single execution of the SQL statement.
    Last Returned Rows	The number of rows returned by the last execution of the SQL statement.
    Total Logical Read Count	The total number of logical reads for the SQL statement.
    Average Logical Reads	The average number of logical reads per execution of the SQL statement.
    Minimum Logical Reads	The minimum number of logical reads in a single execution of the SQL statement.
    Maximum Logical Reads	The maximum number of logical reads in a single execution of the SQL statement.
    Last Logical Reads	The number of logical reads from the last execution of the SQL statement.
    Total Physical Read Count	The total number of physical reads for the SQL statement.
    Average Physical Reads	The average number of physical reads per execution of the SQL statement.
    Minimum Physical Reads	The minimum number of physical reads in a single execution of the SQL statement.
    Maximum Physical Reads	The maximum number of physical reads in a single execution of the SQL statement.
    Last Physical Reads	The number of physical reads from the last execution of the SQL statement.
    Total Logical Writes	The total number of logical writes for the SQL statement.
    Average Logical Writes	The average number of logical writes per execution of the SQL statement.
    Minimum Logical Writes	The minimum number of logical writes in a single execution of the SQL statement.
    Maximum Logical Writes	The maximum number of logical writes in a single execution of the SQL statement.
    Last Logical Writes	The number of logical writes from the last execution of 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 of the SQL statement.
    Minimum Logical I/O	The minimum logical I/O in a single execution of the SQL statement.
    Maximum Logical I/O	The maximum logical I/O in a single execution of the SQL statement.
    Last Logical I/O	The logical I/O from the last execution of the SQL statement.
    Last Executed At	The timestamp of the statement's last execution.