← Lab
Drill 2: The database is on fire
The situation
Database CPU sits at 90%. You check: 95% of queries are reads, and most of them fetch the same few thousand product pages. Web servers are at 20% CPU. Data size is a comfortable 40 GB.
What is the cheapest, most effective next step?
How sure are you? Decide before you pick an answer.