Contents
How to view a plan in SentryOne SSMS?
Right-click a plan in SSMS, and then select View with SentryOne Plan Explorer. This opens the plan(s) in Plan Explorer, providing the correct server/database context for further operations. In SSMS, right-click a graphical plan, select Show Execution Plan XML, and then copy and paste the plan XML into Plan Explorer.
How to view a plan in SQL Sentry?
Right-click a plan in SSMS, and then select View with SQL Sentry Plan Explorer. This opens the plan (s) in Plan Explorer, providing the correct server/database context for further operations. In SSMS, right-click a graphical plan, select Show Execution Plan XML, and then copy and paste the plan XML into Plan Explorer.
What does the plan Explorer DO in SentryOne?
Plan Explorer looks past any views and shows the base tables and base columns, making it quicker to analyze queries that involve, for example, nested views. The Parameters tab shows compiled and runtime parameters referenced in the plan, if any exist (otherwise the tab isn’t visible).
How is the top operations tab in SentryOne?
The Top Operations tab contains a sortable list view of all plan operations. The List view is sorted by total cost descending by default so you can immediately see which operations are the highest cost. Copies the selected cell. Copies the selected row. Copies all column data.
Why do we need tool like SentryOne plan explorer?
“Thank you for building the tool the SQL Server team was never able to realize! The much-needed tool which provides the insights into SQL Server internals which everyone who writes a production query should understand.
How do I Move plan from SSMS to plan explorer?
In SSMS, right-click a graphical plan, select Show Execution Plan XML, and then copy and paste the plan XML into Plan Explorer. It doesn’t matter which pane is active; the clipboard handler is global and auto-detects the plan XML. This makes it quick and easy to move plans from SSMS into Plan Explorer if you’re not using the SSMS Add-in.