Global Overview does not display servers
capspay
Posts: 4
Sql monitor is setup and all the servers are showing up as connected but the over view does not list any servers. Is there a setting that needs to be changed in order to view them?
Comments
I can think of two potential issues that would cause this.
a) There is some clockskew between various machines in your setup e.g. your web server and base monitor service machine. A time difference of more than 15 seconds can cause authentication issues.
b) Your browser doesn't have scripting/javascript enabled. Also Internet Explorer is by default substantially restricted on server operating systems and this can prevent SQL Monitor from displaying any dynamic content.
Regards
Chris
Test Engineer
Red Gate
If it was an authentication issue will it still display as connected?
Thanks again for your help.
My thought was that it could be a clock skew difference between the machines that host the web server (either IIS or the one we ship) and the base monitor service. If these two components are on the same machine then I'll have to rethink.
It's unlikely to be a javascript issue if it worked previously so we can discount that one I think.
Test Engineer
Red Gate
I've just discussed this with a colleague and now think it could potentially be a bug whereby the Monitored Servers page is displaying healthy connections (green ticks) when there are actually underlying issues.
Would it be possible for you to locate, zip and email the SQL Monitor log files? These should exist on the machine that hosts the web server + base monitoring service.
More information on how to find log files on this help page:
https://documentation.red-gate.com/page ... Id=2296838
Regards
Chris
Test Engineer
Red Gate