NUMCPUVPs and number of physicial processors
Posted in 1998
Gurus,
We are migrating our Informix 7.23 systems from a SUN 2000 with
14 processors (88 Mhz) to a SUN 6000 with 10 processors (250 Mhz). In
our current configuration, we have :
NUMCPUVPS = 12
CLEANERS = 12
LRUS = 12
We do not use processor affinity.
The system is primarily used for decision support. There are a
few very low volume OLTP apps running.
Should we lower these settings to 10 or less each? If we left
these settings alone, could we expect a performance degradation
resulting from having more CPUVPs than physical processors?
I'm considering creating two instances on the new SUN 6000. One
instance for the small OLTP apps, and one instance for the DSS data. If
I choose this route, could I go with 8 cpuvps for the DSS and 2 cpuvps
for the OLTP apps or possibly 6 and 4?
Currently, performance is excellent. So, you ask why upgrade?
The upgrade is a result of expected load increase resulting from a new
decision support project to be implemented after the migration.
Any comments are appreciated. Thanks in advance.
James May
Database Administrator,
Agency for Health Care Administration, FL
mayj@fdhc.state.fl.us