We do something similar with our in-house programs. (We have racks of
machines that just sit and do OCR processing all day, and it'd be tough
for us to know if they went down. Bear with me, this is actually
relevant, hahaha.)
Every minute, the in-house OCR program running on each machine updates a
record in a SQL table on the central database server. The table has
fields for machine name, program name, quoted time, and actual time of
the insert (per the SQL server). The quoted time is from the machine,
the actual time is a datestamp done by the SQL server.
Then, you would compare the datestamps of the two columns - if they were
significantly different, then you could sound an alarm. I'm a web
programmer, so I see every page as a URL check, and how we do it is to
have a web page that queries the table and only looks for records older
than 5 minutes (indicating the program/machine has stopped responding)
or where the time variance between the machine's time and the server's
time is more than, say, 10 seconds.
We don't actually use SA for this, because the alerting gets kind of
complex from there, but I thought it might be helpful.
Brent
--------------------------------
Brent Ozar - UniFocus
--------------------------------
"She set your goldfish free
And now she's sighing
Blew out your pilot light
And made a wish...."
Twisting, They Might Be Giants
-----Original Message-----
From: Carroll, Andy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:58 AM
To: '[EMAIL PROTECTED]'
Subject: [SA-list] Checking NT Server Times
(this is a 2nd resend of this message as I haven't seen any response and
it
may not have reached the list, apologies if you already seen this...)
I would like to be able to check the time, preferably to the second,
across
a number of servers, currently 13. Does anyone have any ideas how I
could
implement this using SA.
I am monitoring servers that are all running against an Oracle database
system and I need to make sure that there is no significant time lapse
across these servers to avoid problems with the data entered into the
tables.
My initial thoughts are just to use 'net time', creating a batch file
that
pulls the current time from each server and comparing the times, however
this only seems to allow me to check to the minute and I would like
greater
control of this check. Has anyone used any other utility for this sort
of
check that I could possibly add to my SA configuration?
Thanks in advance,
Andy Carroll
Intergraph Public Safety
To unsubscribe from a list, send a mail message to [EMAIL PROTECTED]
With the following in the body of the message:
unsubscribe SAlive
To unsubscribe from a list, send a mail message to [EMAIL PROTECTED]
With the following in the body of the message:
unsubscribe SAlive
