• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

CPU usage

Hi:

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.

0
sdc248
Asked:
sdc248
  • 2
  • 2
1 Solution
 
r-kCommented:
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.
0
 
sdc248Author Commented:
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...
0
 
r-kCommented:
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.
0
 
sdc248Author Commented:
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...
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now