The Query Details view provides various views with detailed information on each query. The Query Details view is comprised of the following tabs:
The Plan Diagram and Plan XML views are only available for instances running SQL Server 2008+.
Plan Diagram
The Plan Diagram 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. Click image to view full size.
In the Plan Diagram view you can perform the following actions:
- Select individual operators and view the set of properties for each operator.
- Increase the size of the image (Zoom in).
- Reduce the image size (Zoom out).
- Select a size for the view so that fits the current view size (Zoom to fit).
- Export image of Plan Diagram.
The top three operators based on the percentage of total cost in a Plan Diagram are highlighted in yellow.
Estimated Query Plans
SQL Diagnostic Manager displays information on whether the plan displayed is an estimated query plan or an actual one.
Plan XML
The Plan XML tab of the Query Details window displays the actual XML of the query execution plan. It has a syntax-highlighting (color-coded) XML viewer. Click image to view full size.
In the Plan XML view you can perform the following actions:
- Export and save XML file for review in other application such as SSMS or email query execution plan to other DBAs.
Save the file with .sqlplan extension to view the graphical query plan in SSMS.
SQL Text
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.
Query Columns
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.