March 15, 2005 at 11:39 am
I'm using SQL Profiler and when looking at the results of a trace, I see a couple of columns that seem helpful, but without the correct unit of measure, are confusing. I'm referring to CPU and Duration. Is Duration the time it takes to complete the task in milliseconds???
How is CPU measured??? What does it really mean???
I have results like below...
CPU Reads Writes Duration
3953234 120210502 416606 4321626
It seems to me that this process is extremely costly, but without the correct terminology, I can not go to the creator and ask them to review the process for efficiency.
Can someone help???
TIA,
Brian
March 15, 2005 at 12:17 pm
CPU --> amount of CPU time in milliseconds
Duration --> Time elapsed for the event in milliseconds
And yes, THAT is costly.
Can you:
1. check the execution plan of that process
2. make sure table scans are non existent or minimized
3. Indexes are being used
4. The Query(ies) is(are) not using more resources than what is really needed
HTH
* Noel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply