Monitoring with Execution Plans - Microsoft SQL Server 2012 Performance Tuning - page 101

You can download the full XML execution plan, 5740_05_01.xml , with the
code snippet of this chapter.
How it works...
XML execution plan provides a lot of crucial information to dig in. We will look at a few of the
important tags from XML file:
The previous screenshot shows the BatchSequence, Batch, and Statement elements which
are the starting tags of the XML file.
F If we have multiple batch or statement in execution, we would have more then one
Batch and Statement element in XML.
F The StmtSimple element displays information about the query we ran and some
physical attribute value at the time of executing the query.
F The Statement SetOption elements make us aware with the value of the SET
environment variables.
F The QueryPlan element gives you an insight regarding the resources and memory
consumed by plan generation task.
F The RelOp elements provide information regarding the operation that is going to
be performed on a statement. An operation such as a table scan, index scan, index
seek, aggregation, sorting, or others would come under these elements along with
more details.