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
Webmaster
SQL-Server-Performance.Com