Sort Symptoms Before Tuning The Wrong Layer
Classify symptoms by likely bottleneck before choosing a tuning action.
Sort each symptom into the likely bottleneck bucket. CPU bound I/O bound Lock contention Network or connection Top query consumes 70 percent CPU and plan changed after a statistics update. Read latency rises, buffer cache hit rate drops, and disk queue depth climbs. Sessions wait behind one open transaction holding row locks for eight minutes. Connection attempts fail intermittently through the proxy while database wait events are normal. A function call scans millions of rows and burns CPU without waiting on disk. Checkpoint and write waits increase after a bulk load starts. Deadlock logs show two services updating the same…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in