On Apr 13, 12:03 pm, "M A Srinivas" <masri...@gmail.comwrote:
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.