Rows - Show line widths by the number of rows created.ĭata Size - Show line widths by the volume of data used.
AZURE DATA STUDIO DIAGRAM PLUS
The default view, costs are per node, representing each individual nodes contribution to the total cost.Ĭosts are cumulative, representing each individual nodes contribution plus the contribution of any of its children. Shows metrics associated with the Estimated Plan. Shows metrics captured during Actual Plan retrieval. The following context menu options are available: Option Note: The SentryOne Plan Explorer ADS Extension is compatible with any theme in ADS. Select the operator to display the operator's detail window. Hover over a Plan Diagram operator to display a truncated tooltip that provides details about the operator.
Through the context menu of the Plan Diagram, choose to show cumulative costs in lieu of per node costs when combined with color scaling, this feature makes it easy to see which subtrees are contributing most to the plan cost. All costs in the Plan Diagram are shown to the first decimal place. CPU + IO is used by default change this through the Costs By context menu. These cost labels use color scaling by CPU, IO, or CPU+IO so highest cost operations are instantly obvious, even on larger plans. The estimated cost of the operation is displayed above each node for maximum readability. Optimized plan node labels prevent truncation of object names in most cases. You can zoom in and out by selecting CTRL + Mouse Wheel. The Plan Diagram uses an optimized layout algorithm that renders plans in a much more condensed view, so more of the plan fits on the screen without having to zoom out. Select View XML to open the ShowPlan XML for the selected statement. Select View Plan to open a detailed query plan of the selected statement. The amount of CPU used to process the query statement. The amount of time in milliseconds it took for the query statement to complete. The Statements tab separates the query into statements, and provides Duration and CPU information about those statements.Īn individual statement within the query.
The Plan Explorer Statements tab opens automatically when a query is run and the Plan Explorer extension is enabled.
Plan Explorer Query Diagram for Estimated Plan
0 kommentar(er)
