Clock skew

SQL Server performance monitoring and alerting

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

Clock skew

Postby kevriley » Mon Nov 15, 2010 2:40 pm

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......
kevriley
 
Posts: 70
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK

Postby Ben C » Mon Nov 15, 2010 3:51 pm

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
Ben C
 
Posts: 15
Joined: Mon Jul 13, 2009 12:56 pm
Location: Red Gate Software

Postby kevriley » Mon Nov 15, 2010 4:03 pm

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.
kevriley
 
Posts: 70
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK

Postby Ben C » Mon Nov 15, 2010 4:12 pm

Do you have VMWare Tools installed on the guests? The support document indicates that it helps with time synchronization.
Ben C
 
Posts: 15
Joined: Mon Jul 13, 2009 12:56 pm
Location: Red Gate Software

Postby kevriley » Mon Nov 15, 2010 4:18 pm

Yes VMware tools are installed on the guest
kevriley
 
Posts: 70
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK

Postby Ben C » Wed Nov 17, 2010 1:53 pm

Hi Kevan

Did you get anywhere with the VMWare document?

Thanks
Ben
Ben C
 
Posts: 15
Joined: Mon Jul 13, 2009 12:56 pm
Location: Red Gate Software

clock skew

Postby thejamie » Thu Feb 20, 2014 7:27 pm

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).
thejamie
 
Posts: 3
Joined: Fri Oct 28, 2011 7:59 pm


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests