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

Andrew Ford wrote: > > 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. Have you run UPDATE STATISTICS? Logging will have an impact on performance. To compare apples with apples, you would have to switch it off again. In other words, with similar H/W, you can expect logging to run slower than without. Do you have KAIO switched on? Even with it on, I can't imagine that NUMAIOVPS set to 1 is enough. Do you really have 49 temp dbspaces and are you using them all? I don't know how clever the temp table fragmentation strategy is, but if it is creating 49 fragments, then it will cause your CPU VPs to thrash around like crazy. If OLTP is more important than DSS, then I would move some virtual memory over to the buffers. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+