RE: one Performance question AIX 4.3, informix 7.31ud4

Rulesh Felix wrote (in HTML) > we have a 2 CPU, 1GB mem, informix 7.31ud4, AIX 4.3 machine hosting 3 production databases >with following sizes > db1 - 58 GB > db2 - 6 GB > db3 - 2 GB > At the moment all the 3 databases are in the same instance. > CPU utilization is on an average 75 % over the course of the day. > we are planning on separating the above databases in 2 seperate instances without upgrading the hardware resources. > instance 1 - db1 > instance 2 - db2 and db3 > just need to find out from the group whether the existing performance will degrade ..? You will need to carve up your 1GB memory between OS, instance 1 and instance 2. This will almost certainly reduce the number of buffers and locks for each instance. This will be a performance hit. While once instance is working its nuts off the other is doing nothing with a couple of hundred MB of buffers doing nothing. The OS will need to share CPU resource between the 2 instances. I do not think it can do this as well as the Informix engine in 1 instance. Our rule of thumb is only one instance for production boxes. Colin Bull _______________________________________________________________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. _______________________________________________________________________ sending to informix-list