Top Queries for one monitored server no longer displaying

cdbzb

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

Robyn

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. 

cdbzb

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.