June 23, 2011 at 6:12 am
Am I missing something with the Showplan XML from the profiler event?
I was expecting having a plan like the "actual execution plan" like SSMS provide but it look like I'm getting the "estimated execution plan" which often result in a different plan from the executed one. For instance, I'm getting only "estimated number of rows" instead of "actual number of rows" from the plan's operators.
I've look on BOL and I didn't find any useful information to determine what kind of plan I get: http://msdn.microsoft.com/en-us/library/ms189318.aspx
What I'm doing wrong or what I've missed about this event?
Ty
June 23, 2011 at 6:34 am
It's not the estimated plan, nor the actual plan. 😀
It's the actual plan, but it gets captured by the trace before the query gets executed. This means that you won't have actual row counts and the like.
Hope this helps
Gianluca
EDIT: fixed typos
-- Gianluca Sartori
June 23, 2011 at 6:39 am
Thank you very much for the answer, I know understand what's going on.
Unfortunately, there's seems to be no "Showplan XML: Completed" event or something similar in the profiler to get the actual execution plan (or is it embedded into an other event?)
June 23, 2011 at 6:44 am
AFAIK no, unfortunately.
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply