CPU usage

Posted on 2006-05-23
Last Modified: 2010-04-13

Is there any way I can control the max CPU usage %?

I have some SQL stored procedures that I run on our server, a Win 2000 with single CPU, 3G of RAM, and a SQL Server 2000 database on it.  While there's no the other processes running I want to be able to run my stored procedures at the full speed of the server. However, every time I run these stored procedures, the CPU usage is always around 25%. I tried running the same stored procedures on some PCs in the office and got to use 50% or higher.

Is there some sort of setting on the server that limits the % of CPU time a process can use? How to change that? Thanks.

Question by:sdc248
    LVL 32

    Accepted Solution

    I doubt if that is the reason. % cpu usage depends on several factors, including the relative speed of the CPU and disk. If the CPU is much faster than the disk (relative to the other computer) then you will see the % cpu usage being lower.

    Author Comment

    Another fact is that running the same stored procedure on this server takes about 2 times of the time it would take if running on the other PCs.

    If taking r-k's comment into consideration, speed of the hard drive could also be the bottleneck?  How do I check the speed of the hard drives?

    Still want to to know whether there's a way to manipulate maximum CPU usage % for a process...
    LVL 32

    Expert Comment

    For checking the speed of the hard drive, you can transfer a very large file to/from that disk, trying to keep other variables from being the bottleneck. Keep in mind that disk speed is not an absolute number, but affected by things like how full the disk is, disk controller speed, fragmentation etc.

    Author Comment

    Thank you for the tips, r-k. Will do that when I got a chance.

    I found the server CPU is hyperthreaded and I disabled that.  Now the CPU usage % raise to about 50%.  I am not sure whether the running time has actually been improved or not though. Need to sit down and test later...

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 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

    22 Experts available now in Live!

    Get 1:1 Help Now