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.