time elapsed between sp completed and RPC completed

• KATHLEEN Y ZHANG

  Hall of Fame

  Points: 3534

  More actions

  July 8, 2013 at 6:59 am

  #279966

  I ran a trace on a slow running remote stored proc call:

  exec db1.mydb.dbo.spInsertSomeRows

  The trace ran on the desination server (db1). I captured the sp:completed and prc:completed events. Noticed that sometimes there was a duration difference between the two events for the same produre call, sometimes more than half a second. Could someone please explain to me what made the difference? Note though other times all were fine, either the duration of the two events were the same, or a couple of millisec away, which was expected.

  Thanks!