duplicating Stat Server datetime

[Vic]

Hi, all,

I was wondering if any of you have tried to have both primary and backup Stat Servers writing into DB. In some of the tables, there is no primary key to compare the tables by except for timestamp. Andif your primary and backup are running on different servers, there is a slight chance that the timestamp generated by StatServer and added into the tables is different depending on whether you look at DB 1 or DB 2.
I was thinking that NTP would solve the problem, but I could not resolve the following problems:
using NTP still does not guarantee that event from TServer arrives to both Stat Servers at the same time. Since the timestamp is generated by StatServer, network lag will cause the value of the time entry into the Login or Status table tobe different.
NTP still cannot guarantee up to microsecond synchronization, thus it is still possible for server a to have the time of 10:59.999 and server b time to already turn to 11:00.000 tus causing the timestamp for a particular event to be different.

How do you deal with it?

The only work around I can think of would mean that the timestamp is needed to be generated by TServer and not Stat Server; however, I wonder why Genesys opted out of doing it this way?