Viewing Top Objects of a DB Instance

Scenarios

RDS for SQL Server provides top object queries to help you identify object-level (stored procedures, functions, and triggers) performance problems of your DB instance.

Constraints

To use this function, submit a service ticket to request required permissions.

Procedure

1. Click in the upper left corner and select a region.
2. Click in the upper left corner of the page and choose Databases > Relational Database Service.
3. On the Instances page, click the target instance name to go to the Summary page.
4. In the navigation pane, choose SQL Analysis and Tunning under DBA Assistant.
5. Select Top Objects to view the following performance data:
   • Avg. Overhead of Real-Time Top Objects

     Table 1 Average overhead

     Parameter	Description
     Avg. CPU Time	Average CPU time taken each time a database object is executed, in milliseconds
     Avg. Execution Duration	Average duration of each execution of a database object, in milliseconds
     Avg. Logical Reads	Average logical reads required each time a database object is executed
     Avg. Rows Returned	Average number of rows returned each time a database object is executed

   • Total Overhead of Real-Time Top Objects

     Table 2 Total overhead

     Parameter	Description
     Total CPU Time (%)	Percentage of the total CPU time of a database object
     Total Execution Duration (%)	Percentage of the total execution duration of a database object
     Total Logical I/O (%)	Percentage of the total logical I/O of a database object
     Total Rows Returned (%)	Percentage of the total rows returned by a database object

     Figure 1 Top Objects
     
   • Real-Time Top Objects

     You can check the performance consumption of database objects in your instance in real time.

     Table 3 Object list

     Parameter	Description
     Object Name	Database object name, including database names, schema names, and object names
     Object Type	Database object type, including stored procedures, functions, and triggers
     Avg. CPU Time	Average CPU time taken each time a database object is executed, in milliseconds
     Avg. Duration	Average duration of each execution of a database object, in milliseconds
     Avg. Logical I/O	Average logical I/O required each time a database object is executed
     Avg. Logical Reads	Average logical reads required each time a database object is executed
     Avg. Logical Writes	Average logical writes required each time a database object is executed
     Avg. Physical Reads	Average physical reads required each time a database object is executed
     Avg. Rows Returned	Average number of rows returned each time a database object is executed
     Total CPU Time	Total CPU time of a database object after the instance is rebooted or the cache is cleared, in milliseconds
     Total Execution Duration	Total execution duration of a database object after the instance is rebooted or the cache is cleared, in milliseconds
     Total Executions	Total executions of a database object after the instance is rebooted or the cache is cleared
     Total Logical I/O	Total logical I/O consumption of a database object after the instance is rebooted or the cache is cleared
     Total Logical Reads	Total logical reads of a database object after the instance is rebooted or the cache is cleared
     Total Logical Writes	Total logical writes of a database object after the instance is rebooted or the cache is cleared
     Total Physical Reads	Total physical reads of a database object after the instance is rebooted or the cache is cleared
     Total Rows Returned	Total rows returned of a database object after the instance is rebooted or the cache is cleared