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@xxxxxxxxxxxxxxxxx // https://www.performing-databases.com ;
Von: "l flatz" <l.flatz@xxxxxxxxxx>
An: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l