How can we help you today? How can we help you today?

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

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?
pamsauto
0

Comments

1 comment

Sort by
  • 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.
    Ben_P
    0

Add comment

Please sign in to leave a comment.