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

Flavio
0

Comments

5 comments

  • 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
    Russell D
    0
  • 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
    Flavio
    0
  • Robyn
    Hi, 

    Have you seen this issue again since? Is there anything we can assist you with right now?
    Robyn
    0
  • 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
    Flavio
    0
  • Jessica R
    Thanks for the update, Flavio! We're glad to hear that. :)
    Jessica R
    0

Add comment

Please sign in to leave a comment.