Can Performance Analysis store the Execution Plan in effect at the time the SQL statement was exe (92409)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Can Performance Analysis store the Execution Plan in effect at the time the SQL statement was exe
Description

Can Performance Analysis store the Execution Plan in effect at the time the SQL statement was executed and captured by PA?
Resolution

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.

Feedback submitted.

Was this article helpful?

[Select Rating]

Title