[Info-ingres] CPU resources needed

[Karl and Betty Schendel]

> On Nov 7, 2018, at 5:05 PM, deneuve01 <deneuve01 at gmail.com> wrote:
> 
> Here's the scenario:
> We have an Ingres 9.2.3 installation on a machine with 96 cores. In order to comply with our licensing, it was restricted to 4 cores. This cut our processing time down by about 75%. 
> Is there a way to estimate the number of CPUs needed in order to sustain our installation at the prior level of performance ? We are on Solaris 10. 


I don't think that there is any good, non-trial-and-error way to estimate.  You can start
by estimating how many simultaneously active queries you need to have running, and
the required core count will be not too far from that number.

4 cores doesn't sound like much.  I would expect the license to give you a grace
period so that you can experiment, and if it doesn't, I would expect Actian to give
you a short term, 96-core license so that you can experiment.  Unfortunately I do
think that some experimenting will be necessary.  With any sort of luck you'll find
that 8 or 10 cores gets you close enough.

Karl