[Info-ingres] CPU resources needed

[Laframboise, André (BAC/LAC)]

Hi,

Not much information to go on. But 96 to 4 cores is quite a step back.
Start with the basics. Do you have any Ingres/Database expertise on site ?  
Make sure queries are running as efficient as possible (indexes, stats, DB configuration parameters, etc.)
Bad queries can grind systems to a half no matter how many CPU you have. 

Then there stuff like I/O performance. Also consider upgrading to a more recent Ingres version. Newer versions have overall better performance (optimizer, etc.)

There are too many aspects to cover in a simple email. Maybe contracting an Ingres expert to get a closer, hands on look.
And of course, other option is to pay Actian to cover the extra 92 cores :)

Good luck

André Laframboise

Conseiller Principal Base de Données, Direction générale de l'Innovation et du Dirigeant principal de l'information
Bibliothèque et Archives Canada / Gouvernement du Canada
andre.laframboise at canada.ca / Tél. : 613-298-1346

Senior Database Advisor, Innovation and Chief Information Officer Branch
Library and Archives Canada / Government of Canada
andre.laframboise at canada.ca / Tel: 613-298-1346

-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org <info-ingres-bounces at lists.planetingres.org> On Behalf Of deneuve01
Sent: Wednesday, November 7, 2018 5:05 PM
To: info-ingres at lists.planetingres.org
Subject: [Info-ingres] CPU resources needed

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. 

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