04-20-2011
It seems like, besides buying more CPUs, you might need to trace the more popular queries to see if they are all triggering index plans. Doing it wrong eats up CPU and makes the disks busy, too -- table scans, page splitting, or just backwards plans. If you can, check for excessive lock waits. It may seem primitive, but many waits are released, in the end, by polling resources, which can be costly.
Also, see which processes are the biggest CPU hogs. Compare a ps -efx across a minute. Check system stats, to see if some executables are exec'd excessively. If a process is called a lot but runs an instant, you have all that startup and shutdown cost but it will never show on ps.
Make sure maintenance and overhead processes are not running too often. Conversely, some RDBMS optimizers need to be run, so tables and indexes are not excessively fragmented, and planning statistics are accurate.
Your cpu and disk are highly loaded, so it does not take much to start a backlog, and then it takes long for it to dissipate. Maybe there are overhead processes you can add scripting to, to make them hold off until loading is low. Are there batch and maintenance processes that can run from a remote host, perhaps slower but acceptably and with lower local overhead?
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
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
4. Solaris
Hey guys
First post... and im not exactly a solaris guru but here goes
Ive setup a solaris 10 box with a raidz2 set of 6 disks...
I have also setup Samba with open shares for some CIFs access...
now my issue is that when i transfer large files to it the network performance contantly... (8 Replies)
Discussion started by: silicoon
8 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. 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
8. 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
9. AIX
In my oracle db server we have 15 cores (power8). The output of the vmstat is as below.
System configuration: lcpu=128 mem=208800MB ent=16.00
kthr memory page faults cpu time
-----------... (18 Replies)
Discussion started by: powerAIX
18 Replies