query plan void

Flavio

After upgrading to 10.2 i will get always an empty query plan .Any idea ?

Russell D

What is in your sql server cache?

SELECT plan_handle,usecounts, cacheobjtype, objtype, size_in_bytes, text, 
    qp.query_plan, tqp.query_plan AS text_query_plan
FROM sys.dm_exec_cached_plans cp
CROSS APPLY sys.dm_exec_sql_text(plan_handle) t
CROSS APPLY sys.dm_exec_query_plan(plan_handle) qp
CROSS APPLY sys.dm_exec_text_query_plan(plan_handle, NULL, NULL) tqp

Flavio

In this moment i have 10314 rows but all of the top 50 query will return no query plan and someone will report error try to refresh page. i will take a snapshoot next time i got this error

Robyn

Hi, 

Have you seen this issue again since? Is there anything we can assist you with right now? 

Flavio

Now all seems working fine. Thanks. I will try to install next major release redgate in future to verify if the problem reappears, because i had it only upgrading to 10.2. Thanks

Jessica R

Thanks for the update, Flavio! We're glad to hear that.