Interpretation of Profiler Results | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Interpretation of Profiler Results

I’ve been tracing a series of inserts into a table. (Clustered index based upon an identity field). SQL Profile is displaying something like the following: Text Data Duration
Insert ….. 13
Insert ….. 16
Insert ….. 0
Insert ….. 0
Insert ….. 0
Insert ….. 16 Any ideas why there seems to be several queries that don’t appear to have a duration? Are they that fast?
The duration you see is in milliseconds, with an error of plus or minus 3. So a 0 could mean the insert was less than 1 milliseconds, or it could be less than 3 milliseconds, because of the error range.
Brad M. McGehee