I have an application that makes RPC calls for a single procedure, most calls run in a few miliseconds. Occasionally the call takes 5-7 seconds. I'm trying to catch an execution plan for one of the long running calls.
If you trace ShowPlan XML and RPC:Complete events, there are multiple events per procedure call. With the volume of user traffic, it's difficult to link specific ShowPlan XML events with RPC:Complete events - which makes it difficult to isolate the query plans for
Is there a column that can be used for both ShowPlan XML and RPC:Complete to link the two? Or is there a way to group query plans by batch?