Performance Engineering
Everything on SkillVeris tagged Performance Engineering — collected across the glossary, study notes, blog, and cheat sheets.
11 resources across 1 library
Interview Questions(11)
What is a Reliable Methodology for Tuning a Slow SQL Query?
A reliable query-tuning methodology starts with measuring, not guessing: capture the query's actual execution plan, identify the single most expensive operatio…
How Do You Analyze a Slow Query Log to Find Optimization Targets?
Analyzing a slow query log means aggregating logged queries by their normalized pattern and ranking them by total cumulative time, not by the single slowest in…
What is a Vtable (Virtual Method Table)?
A vtable (virtual method table) is a per-class array of function pointers that maps each virtual method to its actual implementation, used by the runtime to pe…
What is Capacity Planning and How Do You Do It?
Capacity planning is the process of estimating the compute, storage, and network resources a system needs to handle projected load with acceptable performance…
How Do You Estimate Traffic for a System Design Interview?
Traffic estimation is the practice of deriving concrete request-per-second, storage, and bandwidth numbers from rough business assumptions (daily active users,…
What is Queueing Theory and Why Does It Matter for System Design?
Queueing theory is the mathematical study of waiting lines, and in system design it explains why response latency does not rise linearly with utilization but i…
What is Little’s Law and How Do You Apply It?
Little’s Law states that the average number of requests in a system (L) equals the average arrival rate (lambda) multiplied by the average time each request sp…
Why Does Tail Latency (p99) Matter More Than Average Latency?
Tail latency (measured as p95, p99, or p999 percentiles) matters more than average latency because a system with a low average can still have a meaningful frac…
Latency vs Throughput: What Is the Trade-off?
Latency is the time a single request takes from start to finish, while throughput is the number of requests a system completes per unit of time, and optimizing…
What Is the Cold Start Problem in Serverless Computing?
A cold start is the extra latency incurred when a serverless platform must provision and initialize a brand-new execution environment (download the code, start…
What is Capacity Planning in DevOps?
Capacity planning is the disciplined practice of forecasting the compute, memory, storage, and network resources a system will need ahead of demand, then provi…