Linux Top Command

Posted on 2012-09-07
Last Modified: 2012-09-10
When i run the linux top command it shows my SQL processor utilization from a low of 90% to a high of 206%.  How can the percent utilization be higher than 100?

Also, when i look at the load average it shows me 2%.  Why is there such a variation between the two numbers?
Question by:deklinm
    LVL 68

    Assisted Solution

    Processor utilization of 100% means that one processor's worth is fully utilized.

    So if there are several processors (cores) the utilization might well reach more than 100%
    for a multi-threaded process.

    ps -fm -p <pid>

    will show you all threads of the process with ID <pid>

    Load is not measured in percent, it is the absolute number of runnable threads (running or ready to run) at a given point in time, averaged over the last 1-, 5- and 15-minute intervals.
    LVL 19

    Assisted Solution

    As wmp said, a multi processor/core server, if each processor/core is running at 100% used you get over 100%, dont I know, you'd have thought they would have aggregated it wouldnt you...

    anyway, once you know you can get used to it, even though it does sound a little high if it's like that for long periods.
    LVL 6

    Accepted Solution

    Just to throw in my two sense so to speak, basically you are seeing more than 100% because you have a multi-core/multi-cpu setup. Say you have a quad-core cpu, then potentially you can see 400%, which at that point would be bad...

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Have you ever been frustrated by having to click seven times in order to retrieve a small bit of information from the web, always the same seven clicks, scrolling down and down until you reach your target? When you know the benefits of the command l…
    Join Greg Farro and Ethan Banks from Packet Pushers ( and Greg Ross from Paessler ( for a discussion about smart network …
    Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
    Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now