Slow SQL statements — those with high CPU usage, long execution times, high I/O consumption, or excessive row scans — are a leading cause of database performance issues. Database Autonomy Service (DAS) helps you monitor, identify, and optimize slow SQL statements to keep your databases running efficiently.
Operation video
Solutions
DAS provides three approaches to resolve slow SQL statement issues:
-
View and optimize slow SQL statements for a single instance
-
Use Query Governance to manage slow SQL statements on all instances
-
Enable automatic SQL optimization
View and optimize slow SQL statements for a single instance
-
You can use the Slow Log Analysis feature of DAS to view the trends, statistics, and details of slow SQL statements. For more information, see Slow query log.
-
You can use the optimization feature of DAS Slow Log Analysis to diagnose and optimize SQL statements. For more information, see SQL optimization.
Use Query Governance to manage slow SQL statements on all instances
DAS performs offline data analysis daily at 01:00, automatically tagging slow SQL statements generated by all instances on the previous day. It classifies slow SQL statements by priority, provides administration suggestions, and supports data export for flexible management. For more information, see Query Governance.
Enable automatic SQL optimization
Automatic SQL optimization in DAS diagnoses slow SQL statements, optimizes queries, and creates indexes. When slow SQL statements occur, the service promptly diagnoses and optimizes them to keep your database running in an optimal state. For more information, see Automatic SQL optimization.