Can Performance Analysis store the Execution Plan in effect at the time the SQL statement was executed and captured by PA?
Execution plan of a SQL statement can only be collected by Performance Analysis agent when it runs Change Tracking. The Collector has no ability to collect execution plan when it reads DB memory and catches the SQL statement.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy