Search the practice set
126 questions, 454 terms and 400 topics in 20 areas.
9 results for “Profiling & Optimisation”
Application Performance Monitoring
Instrumentation inside the application that attributes latency and errors to specific code paths, queries and dependencies.
Cardinality Estimation
The planner's prediction of how many rows each step of a query will produce — the input that determines every other choice it makes.
Join Strategies
The three ways a database combines two row sets — nested loop, hash join and merge join — and the conditions under which each is correct.
Rightsizing
Matching provisioned resources to observed demand, rather than to the guess made when they were created.
Profiling & Optimisation
Measuring before optimising, and optimising the dominant term.
Compute Optimisation
Instance families, utilisation, and architecture that wastes less.
Profiling
Continuous CPU and memory attribution in production.
Query Optimisation
Reading a plan, fixing statistics, and finding the real bottleneck.