Regression issue after deploying 14.0.44 from 14.0.42

Answers

• Sujay Redgate › Posts: 58 Bronze 3

  February 3, 2025 6:58AM

  Hi Don,

  
  

  This error is usually observed when the Top Queries Search indexes get corrupted.
   
  

  1. Stop the Redgate Monitor Base Monitor service.
  2. Delete the TopQueries Search folder.This would be typically be at  C:\ProgramData\Red Gate\Redgate Monitor\SearchEngine\SqlQueries
     
  3. Restart the Base Monitor Service
  4. Once the folder is deleted, the indexes will rebuild correctly and the errors would no longer be observed.
      Note: Deleting the indexes will not impact any of the Top Queries. It will only impact the Top Query Search function until these indexes get rebuilt.

   
  Please let us know if this helps.

  
  

  Sujay | Product Support Engineer | Redgate Software
  

  0 · Share on Twitter
• DonFerguson Posts: 210 Silver 5

  February 3, 2025 4:59PM

  This error happens if there is blocking data to display within the time window.  I doubt that's the issue, because this problem manifested itself on all base monitors after applying the upgrade.  And doesn't the query folder have more to do with collecting queries from procedure cache as opposed to active processes?
  
  Anyway as stated in another thread this is reproducible in your live DEMO, so please fix it there and provide an update that addresses the issue.

  0 · Share on Twitter
• Sujay Redgate › Posts: 58 Bronze 3

  February 4, 2025 1:51AM

  Thank you Don for the help with reproducing the issue.

  We are looking into this now and will let you know once there are further updates.
  

  Sujay | Product Support Engineer | Redgate Software
  

  0 · Share on Twitter
• DonFerguson Posts: 210 Silver 5

  February 4, 2025 6:35PM

  Thanks Alex.  I'll update right away and confirm shortly.

  0 · Share on Twitter
• DonFerguson Posts: 210 Silver 5

  February 4, 2025 7:19PM

  I can confirm that the problem appears to be fixed after updating to 14.0.45.

  0 · Share on Twitter