query plan void

• 
  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 August 03, 2020 07:58

  - 0 +
• 
  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 August 03, 2020 08:16

  - 0 +
• 
  Hi, 
  
  Have you seen this issue again since? Is there anything we can assist you with right now?

  Robyn August 26, 2020 11:19

  - 0 +
• 
  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 August 28, 2020 07:53

  - 0 +
• 
  Thanks for the update, Flavio! We're glad to hear that.

  Jessica R August 29, 2020 00:46

  - 0 +

Add comment

Please sign in to leave a comment.