Global Overview does not display servers

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Global Overview does not display servers

Postby capspay » Thu Apr 18, 2013 1:20 am

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?
capspay
 
Posts: 3
Joined: Thu Apr 18, 2013 12:44 am

Postby Chris Spencer » Thu Apr 18, 2013 11:17 am

Hi

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
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Postby capspay » Thu Apr 18, 2013 4:42 pm

Thank you for responding, I probably should have specified before. The overview was displaying a couple of days ago but when we upgraded to version 3.3 is stopped showing up. There is a message that says "You are not currently monitoring any servers" but when you click on the "Manage servers" link it shows all of our servers and it says connected.

If it was an authentication issue will it still display as connected?

Thanks again for your help.
capspay
 
Posts: 3
Joined: Thu Apr 18, 2013 12:44 am

Postby Chris Spencer » Thu Apr 18, 2013 5:24 pm

It's possible that the Manage Servers page shows the servers as connected because that would indicate healthy connections between the base monitoring service and the servers being monitored.

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.
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Postby capspay » Thu Apr 18, 2013 5:38 pm

Yes the web server and the base monitor are on the same server.
capspay
 
Posts: 3
Joined: Thu Apr 18, 2013 12:44 am

Postby Chris Spencer » Thu Apr 18, 2013 5:57 pm

Okay it looks like both my suggestions were incorrect.

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
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests