Einstein famously discovered that all time is in fact relative. This is all very well when travelling at near-light speed or when considering theoretical inter-galactic spacemen, but for monitoring SQL Servers, knowing the correct time can be a big issue.
We’re currently having some pretty brow-furrowing, head-scratching discussions about how to handle the synchronization of time between servers when collecting their monitoring data. If the time on one server differs from that of another, by minutes or even seconds, then it could cause some rather obvious weird behaviour in SQL Response – delays in data display, odd-looking axes on graphs, and even alerts for future events.
So, we thought we’d ask you what your experience of this issue is, and how you think we might handle it. Specifically, we’d like to know:
- Are your server times all synchronized?
- If so, how do you keep them synchronized?
- Have you ever experienced any SQL Server issues because of clock discrepancies?