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
Comments
2 comments
-
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. -
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.
Add comment
Please sign in to leave a comment.