Scoring Rules
This section describes inspection scoring rules.
Points are deducted based on scoring rules. You can view scores on the console.
Scoring rules
Deduction Item |
Description |
Sub-item |
Condition |
Calculation Rule |
---|---|---|---|---|
Memory usage |
Average memory usage per day |
Major event |
Memory usage > 90% |
min[3 + (Memory usage-0.9) x 50, 10] |
Warning |
80% ≤ Memory usage ≤ 90% |
1 + (Memory usage – 0.8) × 20 |
||
CPU usage |
Average CPU usage per day
NOTE:
Multi-core CPUs need to be converted to single-core CPUs. |
Major event |
CPU usage ≥ 80% |
min[3 + (CPU usage – 0.8) × 30, 10] |
Warning |
70% ≤ CPU usage ≤ 80% |
1 + (CPU usage – 0.7) × 20 |
||
Connection rate |
Average connections per day/Maximum of connections allowed in a day |
Major event |
Connection rate > 80% |
3 |
Warning |
70% ≤ Connection rate ≤ 80% |
1 |
||
Active sessions |
Active sessions generated in a day |
Major event |
Active sessions > min(4 × CPU cores + 8, 96) |
9 |
Warning |
Active sessions > min(2 × CPU cores + 8, 64) |
3 |
||
Slow SQL statements |
Slow SQL statements executed per day |
Major event |
Slow SQL statements ≥ 500 |
18 + (Slow SQL statements – 10)/30 |
Warning |
100 ≤ Slow SQL statements < 500 |
4 + (Slow SQL statements - 100)/30 |
||
Optimization |
0 < Slow SQL statements < 100 |
1 + (Slow SQL statements – 10)/30 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.