Re: ideal CPU/Memory relation

From: Neil Chandler <neil_chandler_at_hotmail.com>
Date: Fri, 19 Aug 2022 10:12:41 +0000
Message-ID: <AM8P194MB1628CDFFA175276E99B53739856C9_at_AM8P194MB1628.EURP194.PROD.OUTLOOK.COM>

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 Received on Fri Aug 19 2022 - 12:12:41 CEST