To begin, log into the Foglight Console
Navigate to the Globalview databases dashboard if you are not already there
Select a SQL server or Oracle agent with the SQL PI extension configured
In the SQL PI panel, select the SQL Statements tab
In the bottom half Top SQL Statements chart, an Analyze Plan button is present at the top of the table. This can be used to select the SQL statement to drill into.
In the Change Tracking areas, the user can click on a row that displays an execution plan change.
Filter out the other change tracking categories and then click on one of the execution plan changes.
The execution plan dashboard displays the following content
By pressing the Generate Plan button the execution plan is generated and can be viewed by clicking on Compare Plan.
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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité