I did a quick Google search, know exact match for that title, but there are
a couple of papers from Cary Millsap that are still available... One is
called "why you should focus on LIOs instead of PIOs" and the other is "Why
a 99%+ buffer cache hit ratio is not ok". These papers are a couple of
decades old now, but the fundamental strategy around tuning SQL hasn't
really changed much in that time...
-Mark
On Tue, Jun 29, 2021, 20:18 Lucas Pimentel Lellis <lucaslellis@xxxxxxxxx>
wrote:
Hi,
Does anybody have the "Are you still using cache hit ratios?" paper that
used to be on Hotsos' website?
Kind Regards,
Lucas Pimentel Lellis
