01-04-2017
A couple of observations to add to this thread:
- In post #2 a high %iowait was implied, but it is only 5% in the vmstat output.
- Active memory use avm (without filesystem caching / buffers) is 80GiB. So this is mainly caused by the database and the application combined.
- fr:sr is only 1:2.2 so the system appears to have no problem freeing the memory that it requires.
- fi+fo>fre, and fi is roughly equal to fr, so it appears to be mainly caused by filesystem I/O that needs to be placed somewhere in memory.
- Perhaps we are looking at filesystem cache which has not been curtailed (left at unlimited setting), is what is causing this. Typically with cooked filesystems, filesystem buffers should be kept in check (only enough for I/O optimization) as the database typically is better at handling the caching / buffering. Perhaps it is the application that is causing this...
- The system is reading at 0.5 GiB/s. So - as Bakunin already remarked -if there was no backup or similar activity at the moment the vmstat was produced and if this can be ascribed to database activity, then this would probably be due to sequential read I/O. If this is not expected behaviour, then perhaps the database or the application should be tuned. If that is the case, then I would be inclined to expect the SGA would need to be increased, rather than decreased. But this is speculation of course until this is properly researched. The I/O may also be network I/O caused by the application for example..
- The output of iostat does not show high numbers, so maybe we are looking at network I/O?
- The ps output, you left out the labels, so it is not clear what the numbers mean and also what "top 20" entails
Last edited by Scrutinizer; 01-04-2017 at 06:45 AM..
This User Gave Thanks to Scrutinizer For This Post:
9 More Discussions You Might Find Interesting
1. AIX
Hello everybody.
I have a problem with my AIX 5.3. Recently my unix shows a high cpu utilization with sar or topas.
I need to find what I have to do to solve this problem, in fact, I don't know what is my problem.
I had the same problem with another AIX 5.3 running the same... (2 Replies)
Discussion started by: wilder.mellotto
2 Replies
2. News, Links, Events and Announcements
About 4 years ago I wrote this tool inspired by Rob Urban's collect tool for DEC's Tru64 Unix. What makes this tool as different as collect was in its day is its ability to run at a low overhead and collect tons of stuff. I've expanded the general concept and even include data not available in... (0 Replies)
Discussion started by: MarkSeger
0 Replies
3. Solaris
Hello Friends,
On one of my Solaris 10 box, CPU usage shows 100% using "sar", "vmstat". However, it has 4 CPUs and prstat and glance are not showing enough processes to justify high CPU utilization.
=========================================================================
$ prstat -a
... (4 Replies)
Discussion started by: mahive
4 Replies
4. Solaris
Hi All,
While creating zone we will mention min and max cpu cores, like
add dedicated-cpu
set ncpus=NUM_CPUS_MIN-NUM_CPUS_MAX
end
Ques1:
Suppose thing that non global zone uses only minimum cores at particular time What the other cores will do, Will it shared to global zone?
Ques:2... (1 Reply)
Discussion started by: vijaysachin
1 Replies
5. HP-UX
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%.
... (8 Replies)
Discussion started by: GreenShery
8 Replies
6. SCO
hi
We have migrated SCO 5.0.6 into ESX4, but the VM eats 100% of the virtual CPU.
Here is top print from the SCO VM:
last pid: 16773; load averages: 1.68, 1.25, 0.98 02:08:41
79 processes: 75 sleeping, 2 running, 1 zombie, 1 onproc
CPU states: 0.0% idle, 17.0% user,... (7 Replies)
Discussion started by: ccc
7 Replies
7. HP-UX
We have a DB server which is constantly utilised above 95% above.
This is becoming nuisance when the monitoring team frequently calls to check on it. Frankly I do not know what to tweak or even interpret the outputs.
I noticed constant 30 to 60% in wio column of the cpu utilisation.
There... (1 Reply)
Discussion started by: sundar63
1 Replies
8. Shell Programming and Scripting
I want to write a shell script which will print AIX
CPU utilization
memory utilization
every 5 mins redirect to file. How do i do it? Please advise.
Which commands I should use? (3 Replies)
Discussion started by: vegasluxor
3 Replies
9. Solaris
Hi all,
Been reading a lot of the cpu load and its "analogy of it to car traffic path of expressway"
From wiki
Most UNIX systems count only processes in the running (on CPU) or runnable (waiting for CPU) states. However, Linux also includes processes in uninterruptible sleep states... (13 Replies)
Discussion started by: javanoob
13 Replies