Slow Query Logs

Procedure

1. Log in to the DAS console.
2. On the Overview page, click Go to Intelligent O&M.
3. Select the target instance and click Details.
4. Choose SQL > Slow Query Logs to view log trends of the instance.
5. Set a time range or select Last 1 hour, Last 6 hours, or Last 1 day to view slow query logs, CPU usage, and archived slow query logs.
6. Toggle on Enable DAS Slow Query Log. In the displayed dialog box, read and agree to the security agreement, and click OK.
7. At the lower part of the Log Trends page, view statistics and details of slow query logs.
   • Query and view slow query logs by database name.

8. On the Log Archiving tab page, obtain the slow query log files of the current DB instance in either of the following ways: (The archiving function saves slow query log files generated in the last 10 days.)
   • Click Generate Latest Log File.
   • DAS automatically generates a slow query log every time the log data reaches 50 MB.

9. In the slow query log list, locate the log that you want to view and click Download to download log data.