How do I fix "Query Plans not Found" or "Recommendations could not be loaded because query plan..."

pamsauto

This is a new install of SQL Monitor on a fresh Windows 10 VM.   I am able to see some Query Plans, but not all.   I flagged a specific query to be tracked and this query never has a query plan to look at in History or if you see it in Current Activity.

I looked at log files and didn't see any issues, so how do I figure out what the issue is?

Ben_P

Hi @pamsauto

There is the possibility that SQL Server did not have the plan for us to sample.  You can check by running this query on the target entity, filling in the plan handle with the one shown in the SQL Monitor UI:

SELECT query_plan FROM sys.dm_exec_query_plan(planHandle)

This is also why the recommendations can't load, because the query plan is used to provide the recommendations.