The Query Details view provides various views with detailed information on each query. Click image to view full size.
The Query Details view is comprised of the following views:
The Plan Diagram and Plan XML views are only available for instances running SQL Server 2008+. |
The Plan Diagram is a visual representation of the query execution plan 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's percentage of total cost . Click image to view full size.
In the Plan Diagram view you can take the following actions:
The top three operators based on percentage of total cost in a Plan Diagram are highlightened in yellow. |
The Plan XML tab of the Query Details window displays the actual XML of the query execution plan. It has a syntax-highlightening (color-coded) XML viewer. Click image to view full size.
In the Plan XML view you can take the following actions:
Save file with the |
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 take the following actions:
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 take the following actions:
Idera Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
---|