Increase cache hit rate
mathjazz opened this issue · 1 comments
mathjazz commented
Our table cache hit rate currently stands at 0.85 and is consistently below the recommended value of 0.99. In such case it is recommended to upgrade database plan for more RAM.
As per the docs, the best way to understand what plan is best for your workload is to try them.
Our initial testing didn't show significant gains, but that could have been caused by cold cache.
mathjazz commented
Upgraded plan on prod to Standard 2 today. Let's observe how that affects the cache hit rate and the overall performance.