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