Customers report high database response latency, slow business queries, and excessive CPU usage during the morning rush hour. As a solution architect, you should prioritize analyzing the SQL…

Customers report high database response latency, slow business queries, and excessive CPU usage during the morning rush hour. As a solution architect, you should prioritize analyzing the SQL statements in the slow log that have a high number of executions, long execution times, and a large number of rows scanned. Use the SQL diagnostic tools in the DAS to analyze slow SQL statements and take action based on the diagnostic findings, such as creating indexes on key fields.