Actual Query Plan button not working. SQL Server, TDP 6+

amlloyd · January 3, 2024, 3:49pm

Enabling the actual execution plan only generates the estimated, not the actual. This has been an issue for a while, at least since 6.0.

Tested on SQL Server:

SQL Server 2016 SP2
SQL Server 2019

Gary.Jerep · January 3, 2024, 5:25pm

I can't seem to get the actual plan either for queries executed... raising to Quest R&D.
Would be helpful, if you haven't already, to create a Support ticket.

amlloyd · January 3, 2024, 5:59pm

Didn't even think about submitting a ticket, thanks for the suggestion.

Gary.Jerep · January 18, 2024, 5:53pm

OK, well, I raised the issue to Quest Dev, and they also are able to reproduce the issue.

The Dev team did identify a work-around, which is to toggle on the option to include the actual plan via the Editor main menu. Snap below. Hope this helps for now.