Database Autonomy Service (DAS) provides diagnostic reports of database instances. You can create diagnostic reports for an ApsaraDB for MongoDB instance to check its status when performance issues occur or during routine inspections. This helps you evaluate the health status of your MongoDB instance from multiple dimensions such as slow SQL queries, tablespace, and performance trends.
Prerequisites
Make sure the database instance is ApsaraDB for MongoDB.
You can diagnose only secondary nodes, not primary nodes.
Procedure
Log on to the DAS console.
In the left-side navigation pane, choose Intelligent O&M Center > 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, click Diagnostic Reports.
Click Create Reports.
You can also click Auto-generating Report Settings. In the dialog box that appears, specify a schedule to automatically generate diagnostic reports.
NoteThe time range cannot exceed one day. If you specify a shorter time range for diagnostics, more detailed statistics are collected in the diagnostic report.
Refresh the page to view the diagnostic progress. After the diagnostic task is complete, find the diagnostic report that you want to view and click View Report in the Actions column to view the details of the report, including the score.
Related links
For information about how to analyze and solve slow SQL queries, see Slow query log analysis.
For information about how to analyze and solve issues related to storage usage, see Storage analysis.