How do you use cloud databases? Take the survey.

query plan void

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

Tagged:

Answers

  • 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
    Have you visited our Help Centre?
  • FlavioFlavio Posts: 4 New member
    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
  • Hi, 

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

    Robyn Edwards | Redgate Software
    Have you visited our Help Center?
  • FlavioFlavio Posts: 4 New member
    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 RJessica R Posts: 1,319 Rose Gold 4
    Thanks for the update, Flavio! We're glad to hear that. :)

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.