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

You can download the full XML execution plan, 5740_05_02.xml , with the
code snippet of this chapter.
How it works...
XML actual execution plan provides a lot of crucial information to dig in. We will understand a
few of the important tags from the 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. Operations such as a table scan, index scan, index
seek, aggregation, sorting, and others would come under these elements along
with more details.