Recently I have found with the help of one of the Bent Ozar, scritps. One called spBlitzCache.
And found some disturbing when the script tried to get the plan for a specific query.
The meseage says that it cant find a plan for this query. Possible reasons include SQL RECOMPILE and encrypted code.
I have reviewed the suspect query and found no sentences with this code.
Do you know some other reasons to get this strange behaivor?
Thank you in advance.