performance-concurrency-advisor

Diagnose concurrency bottlenecks by analyzing latency metrics, traces, SQL plans, connection pool metrics, and thread dumps. This identifies the true constraint causing slow endpoints or pool saturation in Kotlin Spring services to justify a minimal high-impact fix.

Reactive coroutines block unexpectedly when I/O latency, thread pool contention, or database locking occurs. Evidence-driven analysis of thread dumps and traces pinpoints the exact blocking code path across typical Spring stacks to resolve the constraint.

Identify N+1 query issues by evaluating SQL plans and traces alongside connection pool metrics. This layered diagnosis isolates query execution contention from other latency sources to provide actionable recommendations for database optimization.

Bottleneck analysis works directly with standard Spring connection pool metrics, relying on real signals like latency data, SQL plans, and GC signals. It applies to typical Spring stacks experiencing pool saturation or contention without requiring custom instrumentation.

Thread dumps and GC signals are needed for latency analysis when coroutine blocking, thread contention, or memory pressure disrupts throughput. These signals reveal the true underlying constraint across I/O, pools, and caches beyond standard query performance metrics.