Red Gate forums :: View topic - 3.1.0.125: CLOCK SKEW Fixed over 35 minutes - still "Active"
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

3.1.0.125: CLOCK SKEW Fixed over 35 minutes - still "Active"

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



Joined: 25 Jul 2005
Posts: 511
Location: Costa Mesa, CA, USA

PostPosted: Wed Jun 06, 2012 1:21 am    Post subject: 3.1.0.125: CLOCK SKEW Fixed over 35 minutes - still "Active" Reply with quote

w32tm /config /update was issued on the problem node and on the Base Monitor server but the HIGH Alert is still "Active".

Why is this, please?
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 511
Location: Costa Mesa, CA, USA

PostPosted: Fri Jun 08, 2012 2:27 am    Post subject: Reply with quote

Code:
Status: Ended Time raised: 5 Jun 2012 1:36 PM Time ended: 5 Jun 2012 9:41 PM

It appears to have taken about 2 hrs 20 minutes after the time was sync'd on the base and node2 for SQL Monitor to realize there was no longer an issue... Is this a bit excessive a lag?

Strangely, we didn't reset the active node until today but on the same day (Jun 5), for 15 minutes there was an apparent skew between the base and node1 of 17 seconds that lasted for only 15 minutes. Curious Confused
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 511
Location: Costa Mesa, CA, USA

PostPosted: Fri Jun 08, 2012 5:40 pm    Post subject: Reply with quote

Per a very helpful response by Brian Donahue:

Quote:
Sometimes clock skew can be prolonged by an overworked virtual machine. I did find this on Stack, maybe it explains your situation with SQL Monitor. http://serverfault.com/questions/28803/what-happens-when-you-sync-your-hardware-clock-in-a-vm

Thanks,

Brian Donahue
Red Gate Product Support


My situation is that the Base Monitor is on a VM and monitors a physical active-passive cluster.

There is reference within the post cited above to a VMWare "tinker" setting that I don't profess to understand but looks like it should always be in place for my kind of architecture.

Hope this helps someone else... Very Happy
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