Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
In the bottom half Top SQL Statements chart, an Analyze Plan button is present at the top of the table. This can be clicked to select the SQL statement to drill into.
This opens a pop up with a comparison of all available execution plans of the selected statement.
Clicking the Open in SSMS button will download a .sqlplan file which can be associated and opened with SQL Server Management Studio
The following video details how-to view execution plans in SQL PI.
Foglight for Databases - Viewing Execution Plans in SQL PI
How to view execution plans in SQL Performance Investigator (SQL PI).
https://support.quest.com/kb/4230302
Database Monitoring | Foglight for Cross-Platform Databases
https://www.quest.com/products/foglight-for-cross-platform-databases
Video Player is loading.
Current Time 0:00
/
Duration 0:00
Loaded: 0%
0:00
Stream Type LIVE
Remaining Time -0:00
1x
2x
1.75x
1.5x
1.25x
1x, selected
0.75x
0.5x
Chapters
descriptions off, selected
captions settings, opens captions settings dialog
captions off, selected
This is a modal window.
Beginning of dialog window. Escape will cancel and close the window.
End of dialog window.
This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.