Re: ideal CPU/Memory relation

Thanks Martin and Neil.

Am 19.08.2022 um 12:26 schrieb Martin Klier - Performing Databases GmbH:
> 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