Profiler: Duration vs Difference between StartTime and EndTime

microsoft.public.sqlserver.tools

5 Nov 2007 5:48 PM

Mark

I was running a profile trace for a client SQL Server 2005 Standard Edition,
SP2. The duration for some of the statements was just under 1 minute,
however for the same statements the difference between the starttime and
endtime were closer to 17 ms.

Which one of these are more accurate? I saw in another posting that
duration was actual time.

If duration is actual time how is it calculated?

Mark

5 Nov 2007 11:09 PM

Adam Machanic

EndTime - StartTime is generally much more accurate than reported duration.
I am not certain how duration is calculated, but I regularly see numbers
that are wildly inaccurate. I still use it, though, simply because it's
quicker to look at and can be filtered :-)

--

Adam Machanic
SQL Server MVP - http://sqlblog.com

Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220

Show quote

"Mark" <marksulli***@rcn.com> wrote in message
news:OPMWsT9HIHA.4880@TK2MSFTNGP03.phx.gbl...
>I was running a profile trace for a client SQL Server 2005 Standard
>Edition, SP2. The duration for some of the statements was just under 1
>minute, however for the same statements the difference between the
>starttime and endtime were closer to 17 ms.
>
> Which one of these are more accurate? I saw in another posting that
> duration was actual time.
>
> If duration is actual time how is it calculated?
>
> Mark
>