Re: ideal CPU/Memory relation

Hi Frits,

thanks a lot. You are exactly correct.  Nothing worse than to discuss with a doctrinaire.
I recently had a discussion with a security guy. Obviously I am forbidden to copy customer data. He argued that displaying data on a screen does create a copy. 😠

Thanks

Lothar

Am 19.08.2022 um 12:25 schrieb Frits Hoogland:
> There is no single ratio that is optimal for all use cases of any database.
> But that is the gist of what everybody else is saying here.
>
> Be aware that most benchmarks typically are done for a single use case, and thus allow more to be sized with a fixed ratio, whilst in real life there is no single use case for a database, unless it's very specific (like Martin Klier mentioned).
>
> In fact, I had a huge twitter discussion with the CTO of an OLTP database, where I stated that no real life database strictly is OLTP and not all queries are known and tuned.
> His persistent view was that 'for OLTP, all the queries are always known and completely tuned'.
> Oh the irony, as many on this list have been working on getting the issues that come from this solved for many years, and many years to come.
>
> Frits
>
>> On 19 Aug 2022, at 12:17, Stefan Koehler<contact_at_soocs.de> wrote:
>>
>> Hello Lothar,
>> there are such databases like SAP HANA that use such an approach - quoting doc: "Using core-to-memory ratios which can be derived from the certified HANA listings. The memory requirement drives the number of cores required."
>>
>> ... but I guess you are using Oracle and never have seen such guidelines in the field until yet :-)
>>
>> Best Regards
>> Stefan Koehler
>>
>> Independent Oracle performance consultant and researcher
>> Website:http://www.soocs.de
>> Twitter: _at_OracleSK
>>
>>> Lothar Flatz<l.flatz_at_bluewin.ch> hat am 19.08.2022 09:02 CEST geschrieben:
>>>
>>>
>>> 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
>>
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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