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?