Re: ideal CPU/Memory relation

Neil,

true. My intention was to tell that I am very much on the too-many-cores-for-large-RAM side of the world. :)

But obviously, having 16 cores for 1/2TB of SGA will not work either, usually.

Stay safe,

-- 
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: "Neil Chandler" <neil_chandler_at_hotmail.com>
> An: "Martin Klier" <martin.klier_at_performing-db.com>
> CC: "l flatz" <l.flatz_at_bluewin.ch>, "Oracle-L Freelists"
> <oracle-l_at_freelists.org>
> Gesendet: Freitag, 19. August 2022 12:12:41
> Betreff: Re: ideal CPU/Memory relation

> You don’t want a huge SGA (eg 1/2 TB) with very few CPU’s to process such a
> large cache. Whilst it’s small beer compared to a bad SQL and poor schema
> design, it can still impact overall performance having insufficient spare CPU
> to handle the large memory footprint.

> Neil.
> sent from my phone



>> On 19 Aug 2022, at 10:21, Martin Klier - Performing Databases GmbH


>> <martin.klier_at_performing-db.com> wrote:




>> 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