SQL Profiler-Duplicate events for same stored procedure
Posted on 2011-09-17
I ran sql profiler with Template as "TSQL_Duration" for a stored procedure(A) which inturn calls couple of other stored procedures(B,C,D) from within it.
I see Two RPC:Completed event for the same stored procedure(D) in sql profiler.
Why does this happen?
First RPC:Completed event for stored procedure (D) takes 47 ms and
the second RPC:COMPLETED event for the same stored procedure (D) takes 40 ms.
So should I add those up and take that as the total duration for that stored procedure D (or) do an average of it?