Performance statistics
Database Autonomy Service (DAS) allows you to query the performance statistics of an ApsaraDB RDS for SQL Server instance, view the performance statistics in histograms, and update the performance statistics at the earliest opportunity. This helps you view the status of the instance.
Limitations
This feature does not support RDS instances running SQL Server 2008 R2 with standard SSDs or enhanced SSDs (ESSDs).
View and manage performance statistics
-
Log on to the DAS console.
-
In the left-side navigation pane, click Instance Monitoring.
-
Find the instance you want to manage and click its instance ID. The instance details page appears.
-
In the left-side navigation pane, click Performance Optimization, then click the Statistics tab.
-
On the Statistics tab, review the performance statistics for the instance:
-
Statistics Overview: Shows an overview of all current performance statistics for the instance.
-
Statistics Not Updated: Shows histograms of statistics that have not been updated.
-
-
Use the following actions as needed:
Action How to use What happens Update Statistics Click Update Statistics, then click OK in the confirmation message. DAS asynchronously triggers a statistics update at the backend. Recollect Click Recollect, then click OK in the confirmation message. DAS asynchronously collects instance data again. Refresh the page after a few minutes to see the updated data. Save as PDF File Click Save as PDF File. Downloads the current page data to your computer as a PDF file. Custom Search Click Custom Search, configure filter conditions in the dialog box, then click Submit. Queries statistics based on the filter conditions you specified.