Red Gate forums :: View topic - Clock skew alert
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Clock skew alert

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
xdai



Joined: 31 Dec 2008
Posts: 69

PostPosted: Tue Jan 22, 2013 4:37 pm    Post subject: Clock skew alert Reply with quote

Hi,

we are currently on latest version of sql monitor, i would like to know what clock skew alert is about? thanks
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Wed Jan 23, 2013 9:59 am    Post subject: Reply with quote

Hi

This alert will be raised when the difference between the Base Monitor clock time and the monitored server clock time is greater than fifteen seconds.

This is important because large time differences between machines can cause authentication issues which will prevent our software monitoring correctly.

I hope this helps

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
xdai



Joined: 31 Dec 2008
Posts: 69

PostPosted: Wed Jan 23, 2013 5:37 pm    Post subject: Reply with quote

Hi,

I do see the servers threw the alert has the same time as the base monitor server. thanks
Back to top
View user's profile Send private message
tristans



Joined: 21 Mar 2013
Posts: 1
Location: Canada

PostPosted: Thu Mar 21, 2013 8:04 pm    Post subject: Re: Clock skew alert Reply with quote

xdai wrote:
Hi,

we are currently on latest version of sql monitor, i would like to know what clock skew alert is about? thanks


I'm getting the same message every day at seemingly random times. My base monitor and SQL server are the same machine so I don't see how this can even be possible. Can you please advise on how to fix this alert?
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Tue Apr 02, 2013 11:31 am    Post subject: Re: Clock skew alert Reply with quote

tristans wrote:

I'm getting the same message every day at seemingly random times. My base monitor and SQL server are the same machine so I don't see how this can even be possible. Can you please advise on how to fix this alert?


First of all, apologies for the very late reply.

This does sound a bit crazy. Can you confirm that the SQL Server you mention is the server you are monitoring as opposed to the server that hosts the SQL Monitor data repository?

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
Tradebridge_DBA's



Joined: 20 Feb 2013
Posts: 2
Location: South Africa

PostPosted: Wed May 15, 2013 12:03 pm    Post subject: Reply with quote

Is there a way to change the clock skew alert to to either higher or lower value...?


regards,

Ian
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Wed May 15, 2013 2:12 pm    Post subject: Reply with quote

Hi Ian,

No, it is not currently supported.

Thanks,
Priya
Back to top
View user's profile Send private message
Lynchie435



Joined: 20 May 2013
Posts: 11

PostPosted: Wed May 29, 2013 5:04 pm    Post subject: Re: Clock skew alert Reply with quote

tristans wrote:
xdai wrote:
Hi,

we are currently on latest version of sql monitor, i would like to know what clock skew alert is about? thanks


I'm getting the same message every day at seemingly random times. My base monitor and SQL server are the same machine so I don't see how this can even be possible. Can you please advise on how to fix this alert?


I echo Tristan here, I also seem to be getting the message at seemingly random times and both the Base Monitor and Data Repository are on the same server.

Regards,

James
Back to top
View user's profile Send private message Send e-mail
JoeGT



Joined: 13 Jun 2012
Posts: 32

PostPosted: Sun Jun 09, 2013 10:36 pm    Post subject: Reply with quote

I have exactly the same situation and raised a ticket with Red Gate support who have spent a fair amount if time investigating :

http://www.red-gate.com/MessageBoard/viewtopic.php?t=16898&highlight=clock+skew

However still no resolution.

I am monitoring 14 instances and 10 of them (only the ones that are member of an SQL cluster), continue to get these alerts multiple times a day.

One of the suggestions from Red Gate support was that the query of the instance for clock time takes too long to return a result and so the clock skew is actually a false positive.

I am loathe to turn this alert off as then if there was a genuine reason for actual clock skew, I would probably only know when I started to see other issues resulting from a lack of clock synchronization between my various servers.
Back to top
View user's profile Send private message
Micke



Joined: 19 Mar 2012
Posts: 2
Location: Stockholm

PostPosted: Wed Jun 12, 2013 6:16 am    Post subject: Reply with quote

We also have this problem with all of our monitored servers, 14 physical hosts running failover cluster instances and one stand alone server. All servers including the one running SQL Monitor are physical.

The alert gets triggered at different frequencies, from around every 4-5 minutes on some machines to just a few per day on others. I have compared the Windows clock on the monitored servers with the server running SQL monitor and they do not differ more than 1 second, but the alerts reports up to 50 seconds of time difference.

All clock skew alerts get automatically ended the next minute, for example:
Time raised: 12 Jun 2013 6:23 AM
Time ended: 12 Jun 2013 6:24 AM

Is the clock skew check a WMI call or SQL query?

Servers are running SQL 2008R2 SP1 or SQL 2012 RTM, all on Windows 2008 R2 SP1.
SQL Monitor version 3.4.0.392.

Regards,
Michael
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group