Query Plans

Introduction

The Query Plans tab lists all plans collected for Top SQL completed queries for the specified date range, and provides a detailed chronology of all completed query plan changes. Use Query Plans to look back at any point in time to see when a plan change led to a query performance problem. 

The Show Totals toolbar button controls whether the grid lists plans are grouped by stored procedure.

Jump To > Query Plans tab by highlighting a range on the dashboard as usual. For example, if you see a spike in parallelism waits on the SQL Server Waits chart, highlight the spike, and then select Jump To > Query Plans. Sort by the Parallel Operations column to determine which queries caused the spike.

Display Panes

Display Pane	Image
The Filter pane allows you to filter the Query Plans by SQL Server.
The Bottom pane lists the records matching the current filters. There are two modes for this pane: Default and Totals.
Default lists all events for the active date range in a standard list format, sorted in order by Database name, Object name, and Plan Creation Time (descending).
Totals lists all events for the active date range in a standard list format, sorted in order by Database name, Object name, and Plan Creation Time (descending).

Controls

Top Pane

After changing the filter, select Refresh , or press F5 to apply the filter.

Bottom Pane

To open the plan in the Query Plan Analysis window, select the Open button under the Plan column. (If the Show Totals button is selected, you need to expand the Database Name to see the Plan column).