Re: Online 5 to 722 Performance

In article <355807F3.54B5@mcmail.com>, Paul Watson <watson@mcmail.com> writes >Art S. Kagel wrote: >> >> Paul Watson wrote: >> > >> > This weekend upgrade a server from Online 5.x to 7.22.UC5. Everything went >> > except the 722 runs 75-100% slower than 5. All the index's have been >> > rebuilt and updates statistics have been run as per the release notes. >> > >> > I think I might be seeing the recent 7.23 and 7.24 Tech alert behaviours. >> > >> > Anybody any ideas. >> > >> > BTW the box is a Sun 1000/4 Processors/312MB complete with SSA. Raid is not >> > being used, neither is mirroring. There are 3 CPUS bound to the engine, >> > the disk accesses are all under 8ms. The thread profiles are poor though. >> >> For best 5.xx like performance make sure that OPTCOMPIND is set to zero >> (0) in your ONCONFIG file! You should also go for 7.24UC5 or later or >> 7.3UC2 or later which fixes many problems introduced in 7.22 and 7.23. >> Also what version of Solaris are you running? Only 7.24UC5 and later >> are certified for the latest version of Solaris. >> > >Setting OPTCOMPIND from 2 to 0 makes no difference. Weird eh! After >each engine change the 4ge was recompiled, shouldn't make a difference I >know but ..... > >What I find really odd is the following > >Import the data, run time = 30 minutes >Import the data, run 'update statistics', run time = 30 minutes >Import the data, run 'update statistics high/low etc', run time = 30 >minutes > >Solaris 2.5.1 and as far as I can tell all the patches are in place. >The machine was recently setup by Sun themselves as the Sun reseller was >unable to get the box stable. > >BTW the disk access times are significantly better than under 5. >Everything seems to point to either statistics problem or memory. The >thread profiles are about 30-40% of what I would expect to see. From >the sqexplain there are only index reads and most of them are >key-only. > > >> Art S. Kagel > How many CPUs? How much memory? sar -p 1 1 run twice shows? sar -d 1 1 run twice shows? onstat -g seg shows? onstat -g ath and onstat -g glo show? onstat -c gives? -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care