There might be some problem with my server,
because every morning at 7, it's performance become bad with no DB extra deadlock.
But I just couldn't figure it out.
Please give me some advise, thanks a lot...
According to the CPU performace chart, Daily CPU loading Maximum: 42 %, Average:36%.
But I have a serious Report Delay for almost half hour.
Here is the "TOP", at the same time but the next day I collect.
"midaemon" is part of MeasureWare. Whether you need it running 24/7 depends on whether you are using MeasureWare to monitor your system performance in detail and whether you have enough disc space to hold the files it creates in /var/opt/perf/datafiles .
The on/off switch for "midaemon" is in /etc/rc.config.d/mwa .
If it is not running it will start itself for the duration of a "glance" session.
Using "glance" itself the following options are useful clues about performance:
m = memory report
t = system tables
B = global waits
i = i/o by filesystem
The figures you post don't show a system under great stress. The disc utilisation is so low that I wonder if the active portion of the database fits into its own buffers or whether you have very slow discs. Normally I would expect a database system to be disc-bound. I can't imagine that anyone would configure Informix to use raw disc nowadays but that might be an explanation.
Methyl would agree, we know not much of this system except it has 2 CPU and seems to run HP-UX 11.11...
I agree with methyl's last post and find the figures quite different from the initial post, I, like methyl would have appreciated the output of the command:
swapinfo -tam
Do you have batch running evening/night ?
---------- Post updated at 15:13 ---------- Previous update was at 15:07 ----------
What does:
grep Physi /var/adm/syslog/syslog.log
produce?
For comparison here is the output of my favorite box:
B3692A GlancePlus C.03.50.00 16:32:44 ant 9000/800 Current Avg High
------------------------------------------------------------------------------------------------------
CPU Util S SN NRU U | 57% 48% 77%
Disk Util F F | 16% 23% 71%
Mem Util S SU UB B | 49% 49% 49%
Networkil U UR R | 19% 19% 19%
------------------------------------------------------------------------------------------------------
PROCESS LIST Users= 14
You say the CPU load is low but according to the CPU summary from the top output you have given us there is not much spare CPU capacity:
when you look at the idle columns...
I find running mpstat while a system is busy because it will show if your CPUs are I/O bound.
Adding a "top -b" into a log file in cron can be helpful to see what the resource hungry processes are at that time, where as all the other tools (sar, vmstat, mpstat) show you how busy the system is they don't show what processes are responsible!