Description of the SQL Performance Summary Dashboard

This image is a screen capture of the SQL Analytics page and shows the Performance Summary of SQLs across databases and applications.

Based on performance, the SQLs are categorized as follows:

• Degrading SQLs - 6 of 46
• Variant SQLs - 0 (zero) of 46
• Inefficient SQLs - 22 of 46
• SQLs with Plan Changes - 4 of 46

2 of the 5 degrading SQLs have increasing CPU Time above 50%.

4 of the 6 degrading SQLs are inefficient.

9 of the 22 inefficient SQLs have increasing Other Wait Time above 50%.

1 of the 6 degrading SQLs have increasing I/O Time above 50%.

The Performance Summary section also contains the following links:

• Top SQLs By CPU
• Top SQLs by I/O