Covering slowness, memory/CPU, indexing performance, system thresholds, scalability limits, and resource tuning