Clock Skew

SQL Server performance monitoring and alerting

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

Clock Skew

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

Hi

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.
goldmedal
 
Posts: 12
Joined: Wed Mar 18, 2009 10:06 am
Location: Preston

Postby peter.peart » Wed Feb 15, 2012 12:36 am

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 support@red-gate.com 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
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby goldmedal » Thu Feb 16, 2012 12:16 pm

Right, the log file has been emailed to support@red-gate.com with "F0057343" in the subject line.

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


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron