Re: Online Performance Probs 5.02.UC7

Issue has now been resolved, its was 1 of 2 things which we changed at the same time. Tables had initially been re-created with page level rather than row locking mode so we swaoor the indexes were not being used. I suspect the latter as it looked like an index thing as the huge IO load was similar to lots of whole table reads and there was no big increase in locks on the system. > We're having major performace problem on our Databse which is manifesting >itself as huge IO amounts, sar -d giving 100% busy & Avque 15+. We did recently >create a number of duplicate tables and then renamed them to their LIVE >versions to allow us to run a procees with minimum downtime(Last shortcut we >take). > We're since ran update stats on the individual tables and it that ran through >fine. Problem is still looking the same though, anyone out there seen anything >like this. It could be something else but the problem did start right after >this work was done so I'm pretty sure that this is the issue. > Its running on a Motorola Unix R40 box and is about 8 GB in size, the tables >themselves are not huge with the largest having around 30K rows. -- Regards Campbell...... +--------------------------------------+-----------------------------------+ | MIS |Pager + 44 (0)1523 610210 | | European Cellular Subscriber |Phone + 44 (0)131-469-6969 | | Easter Inch, Bathgate |Fax + 44 (0)131-469-6970 | | West Lothian EH48 2EH |Direct+ 44 (0)131-479-1424 | | SCOTLAND |EMAIL camk@ei.csg.mot.com | | |Mobile 0802 361437 | +--------------------------------------+-----------------------------------+