Re: one Performance question AIX 4.3, informix 7.31ud4

REBELLO, Rulesh Felix said: > 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 ..? It's hard to say based on the information provided, but I suspect that performance will degrade, as each instance will hog resources in competition with the other. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco Travel broadens a person. You look as if you have been all over the world. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://i2.photobucket.com/albums/y41/Obnoxio/thinkIfoundtheproblem.jpg sending to informix-list