When I run SELECT
queries in SSMS and choose Include Actual Execution Plan, it always includes the SELECT operator. Nice because I can see the full properties like memory grants, cached plan size, subtree cost, etc.
When I run a trace with SQL Server Profiler and grab execution plans via the Performance > Showplan XML Statistics Profile
event, I get all the operators except for the SELECT
. Even when I extract to a file and view the plan in SSMS, it's the same--no SELECT
operator. Is this expected behavior for that particular event? Should I be using some other event to capture the SELECT
operator and its details?
I'm running Profiler from SSMS version 2014, doing traces against a SQL Server 2008 R2 instance.
Also wondering how to capture stats to a trace that I'd get from running SET STATISTICS IO
in SSMS. Or should that already be in the XML Showplan somewhere?