Describe a situation where you identified a major performance bottleneck in production and the steps you took to resolve it.
