SQL Server Performance

Interpretation of Profiler Results

Discussion in 'T-SQL Performance Tuning for Developers' started by jbuckwalter, Nov 21, 2002.

  1. jbuckwalter New Member

    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?
  2. bradmcgehee New Member

    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

Share This Page