Re: NUMCPUVPs and number of physicial processors
On the Sun architecture, it is generally a good idea to have the
CPUVPs <= CPUs. Informix recommends that you use a number that
is a multiple (or factor) of the number of DBspaces.
-d
"May, James" wrote in message <695pub$rui@cssun.mathcs.emory.edu>...
>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
>