SQL Server Performance

Missing MilliSeconds seen via Profiler?

Discussion in 'ALL SQL SERVER QUESTIONS' started by Rich, Mar 4, 2013.

  1. Rich New Member

    Hi Guys,

    I have been trying to improve the inserts between my App to SQL Server 2008 R2 and have spent a lot of time with the Profiler...

    What i cannot figure out is why i am seeing gaps of random milliseconds in my Stored Procedure(s). Even those that should execute in 0 to 2 ms, end up taking 5 to 10 ms here and there. If i can see through this, i can fix something fundamental in my system.

    It is quite hard for me to explain so i have attached some screenshots in the hope that someone can help. And everything i have questions about are highlighted in Red.

    BTW the interface for this forum is pretty slick!

    Thanks!!

    Rich.

    Attached Files:

  2. catullus Member

    Just a wild guess: the column starttime looks like a datetime data type, which is does not have a millisecond accuracy. If this is the column you're looking at, forget it and just focus on duration.

Share This Page