July 25, 2003 at 3:13 am
Hi!
I run Profiler for 2 hours, when CPU usage was about 90%, to figure out who eats most CPU.
I used only these events for my trace:
RPC:Completed and SQL:BatchCompleted.
I not sure if I can make any conclusions out of this.
The reason for my doubt are the following calculations:
the total CPU usage for al events in this trace (SELECT sum(CPU) as sum_cpu
FROM trace_23_07_03_11-13) equals 13 243 775 (in milliseconds, right?)
I have 6xPIII Xeon system that was loaded by 90% (on the average) for two hours.
This would give 6 processors * 2 hours * 60 minutes * 60 seconds * 1000 milliseconds * 90% = 38 880 000 (no parallel execution,- too many users)
So 13 243 775 out of 38 880 000 is about 30% of the whole picture.
Right?
How can I design my trace to see all CPU usage, or at least its most part?
Thanks.
July 27, 2003 at 4:59 pm
Is there a possibility that the culprit CPU-hog continued to run throughout and after the 2 hour trace, therefore not registering as a completed event?
Edited by - mccork on 07/27/2003 4:59:01 PM
Cheers,
- Mark
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply