Re: ideal CPU/Memory relation

Hi Lothar,

for some very vendor specific cases (where I know the database and app server profile very well) we have a minimum rule of roughly 5:1 (GB:Core ratio = 32GB of RAM no less than 6 Cores of Intel 3rd Gen Xeon Scalable CPUs) in our sizing process. That is for a very latency sensitive and CPU-bound workload in automated warehousing (warehouse as in stacking crates), small amounts of data (200GB DB size) and thousands of small transactions per second.

Obviously it does not scale very well to larger memory sizes (who can put 200 CPUs into a machine with 1TB of RAM...?) but does the job here in a satisfactory fashion.

HTH and best regards

-- 
Martin Klier // Performing Databases GmbH 
Managing Partner // Senior DB Consultant 
Oracle ACE Director 
Member of Symposium42 

martin.klier_at_performing-db.com // https://www.performing-databases.com 



> Von: "l flatz" <l.flatz_at_bluewin.ch>

> An: "Oracle-L Freelists" <oracle-l_at_freelists.org>

> Gesendet: Freitag, 19. August 2022 09:02:04


> Betreff: ideal CPU/Memory relation





> Hi,




> had somebody ever heard of a ideal CPU/Memory relation for a database


> server?

> A supplier of a customer stated such thing,

> I suppose they made it up.

> Any comments?




> Thanks





> Lothar

> --

> http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l