Database Autonomy Service (DAS) allows you to view the performance overhead of the top N objects of an ApsaraDB RDS for SQL Server instance. These objects include stored procedures, functions, and triggers.
Usage note
The RDS instance that runs SQL Server 2008 R2 with standard SSDs or enhanced SSDs (ESSDs) is not supported.
Procedure
- Log on to the DAS console.
- In the left-side navigation pane, click Instance Monitoring.
- On the page that appears, find the database instance that you want to manage and click the instance ID. The instance details page appears.
In the left-side navigation pane, choose Performance Optimization > TOP Objects.
On the TOP Objects page, view the performance overhead of the top N objects of the ApsaraDB RDS for SQL Server instance. These objects include stored procedures, functions, and triggers.
The Top Object Overview section displays the time at which the object information was last updated.
Click Save as PDF File to save the object information to your computer as a PDF file.
The Real-time Top Objects - Average Cost section displays the top N objects of the ApsaraDB RDS for SQL Server instance based on the following four metrics: Average CPU Overhead, Average Execution Duration, Average Logical Reads, and Average Returned Rows.
The Real-time Top Objects - Total Cost section displays the top N objects of the ApsaraDB RDS for SQL Server instance based on the following four metrics: Total CPU Overhead in Percentage, Total Execution Duration in Percentage, Total Logical I/O in Percentage, and Total Returned Rows in Percentage.
The Real-time Top Objects - List section displays the details of the top N objects of the ApsaraDB RDS for SQL Server instance.