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
goldmedal



Joined: 18 Mar 2009
Posts: 12
Location: Preston

PostPosted: Mon Feb 13, 2012 4:38 pm    Post subject: Clock Skew Reply with quote

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.
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Wed Feb 15, 2012 12:36 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
goldmedal



Joined: 18 Mar 2009
Posts: 12
Location: Preston

PostPosted: Thu Feb 16, 2012 12:16 pm    Post subject: Reply with quote

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.
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