Describe a scenario where you identified a major performance bottleneck in a production system. What was your process for diagnosing and resolving it?