Page History
The Query Details window provides various views with detailed information on each query. The Query Details view is comprised of the following tabs:
| Note |
|---|
| The Plan Diagram and Plan XML views are only available for instances running SQL Server 2008+. |
| Anchor | ||||
|---|---|---|---|---|
|
The Plan Diagram (estimated) is a visual representation of the query execution plan (actual or estimated) available in XML format in SQL Server. The Plan Diagram displays a view of the tree of operations that make up a query. This tree shows individual operation nodes, pertaining graphical execution plan icon, along with basic information such as operator name and operation percentage of total cost.
...
| Tip | ||
|---|---|---|
| ||
SQL Diagnostic Manager displays information on whether the plan displayed is an estimated query plan or an actual one. |
Anchor xml xml
Plan XML
| xml | |
| xml |
The Plan XML of the Query Details window displays the actual XML of the query execution plan. It has a syntax-highlighting (color-coded) XML viewer.
...
| Warning | |
|---|---|
Save the file with No Format | .sqlplan extension to view the graphical query plan in SSMS. |
| Anchor | ||||
|---|---|---|---|---|
|
The SQL Text tab of the Query Details window shows the underlying SQL Text for the query execution plan.
In the SQL Text view you can perform the following actions:
- Export and save SQL Text for review.
- Access the Plan Diagram, Plan XML, and Query Columns tabs.
| Anchor | ||||
|---|---|---|---|---|
|
The Query Columns tab of the Query Details window shows all the referenced columns for the query execution plan.
In the Query Columns view you can perform the following actions:
- Export and Save information to a text file.