I would suggest a bit of HW tuning. Add a 512GB NVME drive and use it
as flash cache. After that, put your most frequently used tables in
the flash cache and your DBWR will be much faster. You will only need
more DB writers if you're experiencing free buffer waits. Nobody, not
even Kevin Closson, can help you predict your workload without testing.
On Tue, 2020-08-25 at 12:44 -0500, Ram Raman wrote:
List,--
I am considering configuring DBWRs for our new system. I came across
this online: https://kevinclosson.net/category/dbwr-performance/ ;
Does the advice hold true today given the blog is a bit dated? We
are planning on hosting a multi TB warehouse on Linux.
Thanks
Ram
--
