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

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

Clock skew

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kevriley



Joined: 07 Apr 2009
Posts: 70
Location: UK

PostPosted: Mon Nov 15, 2010 2:40 pm    Post subject: Clock skew Reply with quote

I'm getting a lot of 'clock skew' alerts, and within a few minutes of synchronizing the clocks on the base and a monitored server, it is out again by 20 secs or more. The monitored server is a VM - are there any known issues with VMs - not really a SQL Monitor problem I know......
Back to top
View user's profile Send private message
Ben C



Joined: 13 Jul 2009
Posts: 15
Location: Red Gate Software

PostPosted: Mon Nov 15, 2010 3:51 pm    Post subject: Reply with quote

Hi Kevan

We haven't noticed particular issues with clock drift on VMs, but it seems that other people have. There is a question on Stack Overflow about it, and VMWare have a support document.

What VM host are you using? What guest OS? Are the guests in a domain?

Thanks
Ben
Back to top
View user's profile Send private message
kevriley



Joined: 07 Apr 2009
Posts: 70
Location: UK

PostPosted: Mon Nov 15, 2010 4:03 pm    Post subject: Reply with quote

VM Host : VMware Server 2.0.0 on Windows Server 2003 R2 SP2

Guest OS : Windows Server 2003 Ent x64 SP2

Yes all in domain


In the meantime I'll try and digest that support document.
Back to top
View user's profile Send private message
Ben C



Joined: 13 Jul 2009
Posts: 15
Location: Red Gate Software

PostPosted: Mon Nov 15, 2010 4:12 pm    Post subject: Reply with quote

Do you have VMWare Tools installed on the guests? The support document indicates that it helps with time synchronization.
Back to top
View user's profile Send private message
kevriley



Joined: 07 Apr 2009
Posts: 70
Location: UK

PostPosted: Mon Nov 15, 2010 4:18 pm    Post subject: Reply with quote

Yes VMware tools are installed on the guest
Back to top
View user's profile Send private message
Ben C



Joined: 13 Jul 2009
Posts: 15
Location: Red Gate Software

PostPosted: Wed Nov 17, 2010 1:53 pm    Post subject: Reply with quote

Hi Kevan

Did you get anywhere with the VMWare document?

Thanks
Ben
Back to top
View user's profile Send private message
thejamie



Joined: 28 Oct 2011
Posts: 3

PostPosted: Thu Feb 20, 2014 7:27 pm    Post subject: clock skew Reply with quote

We see it on VMWare 5 - most frequently on servers where the RAM exceeds its limit... example: limit is 6 Gig and RAM maxes to 8 GIG and runs an average of 6.7 GIG. (Not sure how it does this - it it only has 6 GIG to play with - anyway, that's what SQL Monitor shows).
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