SkillVaultskills Browse all 500 skills

Performance · Version 1.2.0 · Reviewed 2026-08-02

Connection Pool Tuning Advisor

Locate and remove the dominant bottleneck in pool sizing and timeout configuration with evidence, explicit trade-offs, and a verification plan.

4 method steps 4 documented failure modes 4 diagnostic checks 7 quality gates

Sizes connection pools from concurrency and service time rather than from arbitrary defaults.

₹99 one-time

Get this skill archive

What this skill helps you do

  • Pool sizing
  • Timeout configuration
  • Saturation diagnosis

How Connection Pool Tuning Advisor works

You provide

Baseline measurements, workload shape, and the target

It inspects

Dominant cost mechanism behind pool sizing

It decides

A timeout configuration change ranked by impact and risk

You verify

Re-measure under representative load with guardrails

What it checks first

Connection Pool Tuning Advisor sizes connection pools from concurrency and service time rather than from arbitrary defaults. Use it when the work involves Pool sizing, Timeout configuration, Saturation diagnosis.

  1. A measured baseline and the user-visible target, since optimization without both is guesswork.
  2. Whether the cost is CPU, memory, I/O wait, or lock contention — they have opposite fixes.
  3. The p99 path and how many round trips it contains.
  4. Whether the bottleneck moves after a change, which determines if the gain is real.

Failure modes it recognizes

  • Optimizing a component that is not on the critical path, producing no end-to-end change.
  • A garbage-collection pause misread as slow application code.
  • Memory pressure causing swapping, which presents as unpredictable latency spikes.
  • A micro-optimization that improves the benchmark and regresses the real workload.

Answers it will reject

  • Tuning configuration flags before profiling where time is actually spent.
  • Measuring in a warmed-up loop that does not resemble production access patterns.
  • Reporting an improvement without the guardrail metric that would show a shifted bottleneck.

Decision rules it applies

  • Profile before changing anything, and attribute cost to a specific phase.
  • Optimize the dominant cost first; everything else is rounding.
  • Re-measure under representative load and keep a guardrail metric.

Evidence it asks for

  • Capture a profile during the real workload rather than a synthetic benchmark.
  • Record allocation rate and pause time alongside latency.
  • Compare before and after at the same percentile, not at the mean.

The method inside

  1. Map the artifact, actors, boundaries, and invariants relevant to pool sizing.
  2. Trace concrete failure or abuse paths for timeout configuration; do not report checklist items without a mechanism.
  3. Prioritize saturation diagnosis findings by impact, likelihood, confidence, and cost of correction.
  4. Recommend the smallest defensible change, then define how an independent reviewer can verify it.

Deliverables

  • Pool sizing assessment
  • Timeout configuration decision and action plan
  • Saturation diagnosis verification checklist

Evidence requirements

  • Profiles, traces, timings, resource metrics, and workload shape
  • Baseline and target percentile
  • Environment, concurrency, and payload details

Quality gates

  • Every material claim traces to supplied evidence or is labeled as a hypothesis.
  • The response follows the declared deliverable contract.
  • No execution, access, measurement, or verification is invented.
  • Secrets and personal data are redacted rather than repeated.
  • The user receives a concrete independent verification step.
  • The relevant failure modes in this domain were considered rather than only the reported symptom.
  • No listed anti-pattern was recommended as a solution.

Example task

Input

Under load our app reports connection timeouts while the database shows low CPU and few active queries.

Expected output

That combination means the pool is the bottleneck, not the database. Pool size should follow from concurrency and query service time; also check for connections held across external calls, which is the usual reason a generously sized pool still exhausts...

Boundaries and compatibility

Ideal for

  • Pool sizing: produce a decision or artifact grounded in supplied evidence.
  • Timeout configuration: produce a decision or artifact grounded in supplied evidence.
  • Saturation diagnosis: produce a decision or artifact grounded in supplied evidence.

Out of scope

  • Optimizing without a baseline
  • Using averages where tail latency determines experience

Agent compatibility

  • GitHub Copilot custom agents
  • Claude Agent Skills / SKILL.md
  • Any instruction-following chat model

Tool policy: Advisory by default. No tools are assumed. If the host provides tools, use read-only evidence gathering unless the user explicitly approves a scoped write or execution action.