[Info-ingres] CPU resources needed

[Paul White]

Hi Kris,

I use sar -u and sar -q to get a reasonable idea of peak CPU requirements.
Run during busy periods to see peaks. The daily summary smooths out the
peaks.

This from 8CPU production server supporting 140 Ingres connections.
Artificially loaded up one CPU for 5 seconds.

# sar -u 1 10
Linux 3.10.0-327.el7.x86_64 (mine)  08/11/18        _x86_64_        (8 CPU)

10:55:14        CPU     %user     %nice   %system   %iowait    %steal
%idle
10:55:15        all      0.00      0.00      0.00      0.00      0.00
100.00
10:55:16        all      0.12      0.00      0.25      0.00      0.00
99.63
10:55:17        all      0.12      0.00      0.12      0.12      0.00
99.62
10:55:18        all     11.15      0.00      0.13      0.00      0.00
88.72
10:55:19        all     13.25      0.00      0.38      0.00      0.00
86.38
10:55:20        all     12.62      0.00      0.12      0.00      0.00
87.25
10:55:21        all     12.66      0.00      0.38      0.00      0.00
86.97
10:55:22        all     12.50      0.00      0.12      0.00      0.00
87.38
10:55:23        all      4.76      0.00      0.00      0.00      0.00
95.24
10:55:24        all      0.75      0.00      0.25      0.00      0.00
99.00
Average:        all      6.79      0.00      0.18      0.01      0.00
93.02
#


This from daily report from single CPU server 4 or 5 connections I think.
On average 100% busy for 2 minutes.

# sar -u
Linux 3.10.0-693.11.6.el7.x86_64 (anothersite) 	07/11/18 	_x86_64_
(1 CPU)

00:00:01        CPU     %user     %nice   %system   %iowait    %steal
%idle
...
07:10:01        all      4.60      0.00      6.22      0.07      0.00
89.12
07:20:01        all     21.79      0.00      5.48      0.30      0.00
72.42
07:30:01        all      7.07      0.00      0.53      0.02      0.00
92.38
07:40:01        all      3.62      0.00      1.09      0.16      0.00
95.13
07:50:01        all      0.90      0.00      0.48      0.03      0.00
98.60
08:00:02        all      0.64      0.00      0.42      0.01      0.00
98.93
08:10:01        all      6.75      0.00      6.88      0.57      0.00
85.80
08:20:01        all      0.68      0.00      0.43      0.02      0.00
98.87

Paul


-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org
[mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of Karl and
Betty Schendel
Sent: Thursday, 8 November 2018 9:27 AM
To: Ingres and related product discussion forum
Subject: Re: [Info-ingres] CPU resources needed


> 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

_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres