Top Queries for one monitored server no longer displaying

cdbzbcdbzb Posts: 2 Bronze 1
edited September 25, 2023 10:56PM in Redgate Monitor
Top queries for our most important prod server (of course) are showing as "No significant data to display".  Top waits are also showing as "No significant data to display".  This is a very active server and I know that it is up and running for all users.  I restarted the connection from our base monitor server and it has made no difference.  We are monitoring 74 other instances which are all showing top queries and waits.  Has anyone else run into something similar?  We have not upgraded recently - we are on version 12.1.55.9239
Tagged:
· Share on Twitter

Best Answer

  • RobynRobyn Posts: 195 Gold 1
    Answer ✓
    Hi, 

    Thanks for your post.

    We'd need to troubleshoot this, ideally with log files. Please could you raise a ticket with support@red-gate.com and we'll investigate further. 
    Kind regards

    Robyn Edwards | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter

Answers

  • cdbzbcdbzb Posts: 2 Bronze 1
    Thanks Robyn.  Turns out that this was due to a reboot over the weekend.  Our SQL Monitor server must not have come up correctly over the weekend.  Although restarting the services did not make a difference, a full reboot of the SQL Monitor server cleared the issue up.
    · Share on Twitter
Sign In or Register to comment.