View Source

The Query Details window provides various views with detailed information on each query. The Query Details view is comprised of the following tabs:

Plan Diagram
Plan XML
SQL Text
Query Columns

The Plan Diagram and Plan XML views are only available for instances running SQL Server 2008+.

Plan Diagram

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.

SQL Diagnostic Manager 12.3 > Query Details > image2019-6-23_13-1-32.png

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 operator based on the percentage of total cost in a Plan Diagram are highlighted in yellow.

SQL Diagnostic Manager displays information on whether the plan displayed is an estimated query plan or an actual one.

Plan 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.

SQL Diagnostic Manager 12.3 > Query Details > image2019-6-23_13-21-31.png

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.

SQL Diagnostic Manager 12.3 > Query Details > image2019-6-23_13-12-51.png

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.

SQL Diagnostic Manager 12.3 > Query Details > image2019-6-23_13-14-25.png

In the Query Columns view you can perform the following actions:

Export and Save information to a text file.

Plan Diagram

Plan XML

SQL Text

Query Columns

| | | | | | |