Re: 7.21.UD1 Perf. Problem

On Thu, 19 Jun 1997, Kerry wrote: > We are upgrading a Version 5.03 OLTP system to Version 7.21.UD1, also > upgrading to 4GL 6.05 (pre-release due to bugs in 6.04). Following ONCONFIG file clipped for interest and space: > # Disk Mirroring Configuration Parameters > > MIRROR 1 > MIRRORPATH > MIRROROFFSET 0 This is kindof odd -- mirroring on with no path? > NETTYPE tlitcp,1,13,NET 13 -- is this a little low? > RESIDENT 1 We found that this caused us a significant performance downturn on an HP K260. YMMV, of course. > NUMAIOVPS 2 I'm assuming that KAIO isn't an option on your platform? > SHMVIRTSIZE 8000 With 128mb this could be a little higher -- are you adding any virtual segments during a run? This can take a lot of time on some platforms, and cause overhead due to, er, permissions cacheing I believe. > SHMTOTAL 0 Risky, but not a performance factor. We generally use 75% of real memory for a single instance machine on SHMTOTAL. > LRU_MAX_DIRTY 60 > LRU_MIN_DIRTY 50 You may want to try 1 and 2 -- depends on whether or not you want longer checkpoints or worse overall utilization. > RA_PAGES > RA_THRESHOLD I don't remember what he defaults are here, but this is another good place to tune. > DBSPACETEMP ppkgtemp Assuming that this is declared as a TEMP dbspace? No offence intended, it is an easy thing to forget. > OPTCOMPIND 1 # To hint the optimizer You may want to make this "0" for 5.x like behaviour. Caused us all sorts of grief before we reset to 0 and stopped worrying about it (OLTP). Hrm. Are you seeing the same query paths as you do on your 5.x engine for equ. data and queries? Have you executed an UPDATE STATISTICS HIGH yet? HTH... -Richard