Re: You've heard it all before: newer, faster server runs slower than older, slower server after data migration

From: Andrew Ford <aford@simpletel.com> > >I've seen this problem many times in the news groups, and each time I've >said to myself, "That poor soul, someone spent a load of money for a new >server expecting a performance increase, only to find that the new server >runs dog slow. Thank God I don't have that problem." > >Help, I have that problem. > > >The basics, onconfig and some onstat output at end of message: >HP-UX billsvr1 B.11.00 U 9000/800 >Informix Dynamic Server Version 7.31.FC4 >8 Processors >4 Gig Ram >OLTP/DSS combo, OLTP more important than DSS. > >What we did: >We moved all Informix processing from an 8 Processor, 4 Gig Ram N Class >HP/UX machine to a 8 Processor, 4 Gig Ram N Class HP/UX machine. >The new configuration is connected to an XP256 with roughly 55 47 Gig >Drives and 11 15 Gig Drives (usable in a mirrored pair config) split into >1305 Informix Chunks which make up 454 Dbspaces. Mmmm...moved to XP256, you have? Runs now like dog, you say? Not RAID5, is it? >We started up ER in a Primary/Target config (the large N Class is the >server, replicating to 7 smaller targets), we initially used Unbuffered >logging (the old system used No Logging) but I recently set the logging to >Buffered to help speed things up a bit. Well, duh! That could be half the problem there. >Most of our code has been modified to use Isolation Dirty Read to cut down >on lock contention. ALTER TABLE xxx LOCK MODE (ROW); And it's got nothing to do with that shiny XP256, does it? ># Logical Log Configuration > >LOGFILES 96 # Number of logical log files >LOGSIZE 500 # Logical log size (Kbytes) These logs are *way* too small. >RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) Try -1 >NUMAIOVPS 1 # Number of IO vps Have you got KAIO enabled? :-) If you haven't, that's your problem right there. As far as I can see, it looks OK, otherwise. _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com