At a glance
- Did you know
- Warehouses store data by column, so analytical queries read only the columns they need.
- Rule of thumb
- Keep dashboards off the production database: copy the data to the warehouse.
- Watch out
- Queueing on slots; dashboards go stale.
Its settings in ScaleMySystems
What you can change on it in the lab, and what each number does.
- Concurrency (slots)
- Calls it can work on at once (per instance when autoscaling). Needed slots ≈ calls per second × seconds each takes. Extra calls wait in the queue, then are rejected.
- Queue capacity
- Calls allowed to wait for a free slot. A bigger queue absorbs bursts but adds waiting time; 0 rejects straight away.
- vCPU
- CPU cores available. Needed ≈ calls per second × CPU per request ÷ 1000. Above about 90% busy it slows down and may crash.
- CPU per request (ms)
- CPU time each call burns. Part of what the component is; make the code cheaper to lower it.
- Latency (p50) (ms)
- Typical time one call takes here, before any calls it makes itself. Slots are held for this long.
- Latency (p99) (ms)
- The slowest 1% of calls. Callers must set their timeout above this or they cut off healthy calls.
- Timeout to dependencies (ms)
- How long it waits for each call it makes before giving up. Set it above the dependency’s p99 but low enough that a dead dependency does not hold every slot.
- Error rate
- Share of calls that fail on their own (bugs, declines, flaky tools). An agent that calls it on every step multiplies this.
- Quota (req/min)
- Calls allowed per minute (an API key or provider limit). Calls over it get 429s. Needed = calls per second × 60, with headroom.
Problems that start with it
- Data analyst agent and the warehouse A data-analyst agent writes SQL against a warehouse that runs 8 queries at once, about 800 ms each.
- The prompt cache expires between steps Data-analyst agents send about 82,000 input tokens per step: 26,000 shared (system prompt and tools) plus the task’s growing history. The provider keeps a cached prefix for 5 minutes after its last use and does not count cached tokens against the 3 million tokens a minute quota. Between steps, each agent waits 6–8 minutes for a warehouse query. Times are scaled: a second here stands for a minute.
Full lesson coming soon
Lessons are being added one component at a time: how it works, its settings, a live exercise to break and fix it, interview questions and a short check. See the Circuit breaker lesson for what one looks like.