Posted by TheRealPawn@gmail.com on 04/13/07 16:22

On Apr 13, 12:03 pm, "M A Srinivas" <masri...@gmail.com> wrote:
> On Apr 13, 6:16 pm, TheRealP...@gmail.com wrote:
>
> > I'm trying to get the execution plan for a single stored procedure
> > from Profiler. Now, I've isolated the procedure but I get all
> > execution plans. Any ideas on how to connect the SPIDs so that I only
> > get the execution plan for the procedure I'm watching and not the
> > whole of the server?
>
> You can try use filter on objectname like or if you are executing
> from QA , provide the SPID

Well, we have it filtered down to stored proc and execution tree via
the text data. However, we get all execution tree data not just for
the execution of the stored proc. We won't know the SPID and is very
likely we'll have many SPIDs that we'll see in the trace.

[Back to original message]