performance-concurrency-advisor

Diagnose slow endpoint responses by analyzing runtime metrics, traces, and SQL explain plans to localize the performance bottleneck. The advisor evaluates connection pool contention, downstream HTTP latency, and thread pool starvation to identify the true cause of latency spikes.

Coroutines block unexpectedly in Spring reactive flows due to event-loop blocking or thread pool starvation. Analyzing thread and heap signals alongside recent code changes reveals where blocking operations occur, enabling you to apply minimal changes that restore asynchronous execution.

Finding N+1 query issues causing cache contention requires examining SQL explain plans and trace data to measure query counts and cache miss rates. Evidence-driven localization isolates the exact database access pattern, guiding minimal-change recommendations for optimal caching and parallelism.

Use runtime metrics to fix connection pool saturation in Kotlin by measuring pool contention and downstream latency. The analysis identifies saturated pools using real signals, then proposes the smallest high-leverage change with explicit tradeoffs and a verification plan.

Verify a recommended performance change in a Spring service by following the provided validation plan. The advisor outputs explicit verification steps alongside the recommended change and tradeoffs, ensuring the minimal fix is validated against measured metrics and traces.