Run Queue and CPU Utilization

[Jack Fan]

Dear All,

My company run Baan IV on HP-K580. But performance poor recently. CPU utilization higher and run queue always over 3. What is happend? And How can I do? For detail, Please see the attachment.

[Bill Hassell · Accepted solution]

Solving performance issues is never simple. You can safely assume that most of the problem is caused by the applications. Stop running the apps and performance will be fine, but not a useful choice.

The first (and most obvious) question is: what changed? Did you add more users? Expand the amount of data being managed? Were new database queries added or old ones updated? Was the kernel changed? Were patches added? (and many more similar questions)

If you are running Baan, you will need Glance and Measureware to monitor the system to the level of detail needed to find problems. The classic Unix tools (uptime, sar, vmstat, etc) are clumsy and inaccurate for today's multiprocessor, multi-gigabyte database systems.

[Ruediger Noack]

Hi,

my firstlook to find out the bottlenack is to %wio in sar. Often I found a disk bottlenack that brings poor cpu utilization.
I start sar via cron like this:
0 * * * * /usr/lbin/sa/sa1 600 6

Ruediger