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.
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.