March 14, 2005 at 8:26 am
I am using Profiler to track SQL usage. My question is about Duration. What is this in ? Thousands of seconds ? I cannot seem to find where that is documented.
March 14, 2005 at 8:40 am
yes that column is in milliseconds.
March 14, 2005 at 9:06 am
Great ! Thanks for the quick reply !
March 14, 2005 at 9:12 am
Another question:
So would this be a duration of Wall Clock time or CPU time consumption ?
March 14, 2005 at 9:19 am
can't answer for sure... but I'd assume time clock... since there's a column for the cpu cycles.
March 14, 2005 at 1:09 pm
Duration is the time in ms that took that event to occur. For SP is the Duration of the RPC. For Table Scans is the Duration of the table Scan.
Beware, when you have multiple CPUs, it may be missleading!
HTH
* Noel
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply