Slow Queries

Scenarios

DDM provides a Slow Queries function that sorts out the same type of slow SQL statements within a specified period of time by SQL template. You can specify a time range, search for all types of slow SQL statements within the time range, and then optimize them.

Procedure

1. Log in to the DDM console.
2. On the Instances page, locate the required instance and click its name.
3. In the navigation pane, choose Slow Queries.
4. On the Slow Queries page, specify a time range and view SQL statements executed within this time range.
   Figure 1 Slow Queries page