Sponsored Content
Full Discussion: Performance - CPU spiking
Operating Systems HP-UX Performance - CPU spiking Post 302515654 by DGPickett on Wednesday 20th of April 2011 03:25:55 PM
Old 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

Performance Problem - High CPU utilization

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

Announcing collectl - new performance linux performance monitor

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

In Solaris Zones Dedicated-Cpu Performance?

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

Network writes contantly spiking in throughput

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

Bad performance but Low CPU loading?

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

CPU Performance Problems on VMWARE

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

AIX CPU performance script ?

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

Understanding & Monitoring CPU performance (Load vs SAR)

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

CPU performance

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
iostat(1)						      General Commands Manual							 iostat(1)

Name
       iostat - report I/O statistics

Syntax
       iostat [ -c ] [ -t ] [ disknames ] [ interval ] [ count ]

Description
       The  command  reports  I/O  statistics for terminals, disks and cpus.  For terminals the number of input and output characters are counted.
       For disks the number of 512 byte blocks per second and number of transfers per second are displayed.  For cpus, it provides the	percentage
       of  time  the system has spent in user mode, in user mode running low priority (niced) processes, in system mode, and idling.  On multipro-
       cessor systems these cpu statistics represent a cumulative summary of all the cpus.

       The optional disknames argument causes disk statistics to be displayed for the specified disks.	If this argument  is  not  specified  then
       disk statistics will be displayed for the first 3 disks only.

       The  optional interval argument causes to report once each interval seconds.  The first report is for all time since a reboot and each sub-
       sequent report is for the last interval only.

       The optional count argument restricts the number of reports.

Options
       -c   Displays the percentage of time each cpu spent in user mode, running low priority (nice'd) processes, in system mode, and idling.

       -t   Displays the number of characters read from and written to terminals.

Examples
       This example will cause cpu and disk statistics for the 5 disks ra0, ra1, ra2, ra3, and ra4.
	    iostat ra0 ra1 ra2 ra3 ra4
       This example will cause cpu, terminal, and disk statistics for ra0 to be displayed and updated every 2 seconds.
	    iostat -t ra0 2

Files
See Also
       vmstat(1), cpustat(1)

																	 iostat(1)
All times are GMT -4. The time now is 09:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy