Describe a situation where you had to optimize a slow-running service. What steps did you follow to identify the bottlenecks, and what was the outcome?

``` I first monitored the service's performance metrics using APM tools like New Relic. After identifying long-running database queries, I analyzed their execution plans and optimized each with appropriate indexing. This reduced latency by 50%, improving user experience significantly. ```