Clock Skew

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Clock Skew

Postby goldmedal » Mon Feb 13, 2012 3:38 pm


The Redgate sql monitoring tool (2.3) we use seems to be incorrectly raising “Clock Skew” alerts for one of our sql servers (Microsoft SQL Server 2008 r2 Standard Edition (64-bit) 10.50.1600).

Having checked the time, simultaneously for a period of 5 mins, on both servers (the Base monitor and the sqlserver) it is apparent the time is out by a second or two but not 28 or 40 seconds as the sql monitor tool is indicating.

There was no significant workload on the sql server at the time when the alert was raised.

Any help on this matter will be appreciated.
Posts: 12
Joined: Wed Mar 18, 2009 9:06 am
Location: Preston

Postby peter.peart » Tue Feb 14, 2012 11:36 pm

Thanks for your post and sorry you're running into this. We'd really need to double check the SQL Monitor Base Monitor log files for around the time that this was happening, so are you able to send those across to with a subject line in your e-mail of F0057343? You can find where they are by going to Configuration > About and you'll get the file path they reside in on the machine hosting the Base Monitor service.

It would also be good if you could provide some additional information, such as if the machines you are monitoring are VM's or not.

Many thanks!
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Site Admin
Posts: 362
Joined: Tue Sep 02, 2008 8:58 am
Location: Top floor, RG towers with the cool kids

Postby goldmedal » Thu Feb 16, 2012 11:16 am

Right, the log file has been emailed to with "F0057343" in the subject line.

The sql server in question is named "sqlfin01" and it is not a virtual machine.
Posts: 12
Joined: Wed Mar 18, 2009 9:06 am
Location: Preston

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests