Re: CPU bound on 6 way HP T520/ Online 5 !

In article <te6GbAAmjSR0EwlK@davidlee.demon.co.uk>, David Lee <david@davidlee.demon.co.uk> writes >Hi, > >We are experiencing performance problems, ie slow, (20secs), response >for users tranactions. Hardware and O/S etc are : > >h/w HP T520, 6 processor 1Gb ram, disk EMC Symmetrix >o/s HP-UX 10.10 >Informix 5.x (not sure of version) > >From monitioring using Perfview, we can make the following summary: > >Number of users 360 - 400 with CPU usage between 85 - 100 % >Average CPU 65 % >Memory 60% >Disk access is fine, no bottlenecks. > >Have not been able to tie down high CPU activity to a particular >process, suggestion welcome regarding were to look next . > tbstat -u - see which user is doing the most reads. Proably one or two show >1000 reads. Find out the SQL they are running, runb it in isql with SET EXPLAIN ON; <sql statemnets> and look at your sqexplain.out file. -- David Williams