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.
