Sample Header Ad - 728x90

Can DST transitions cause "random" query timeouts?

1 vote
0 answers
120 views
I have encountered a query timeout ("Execution Timeout Expired") on a sub-second query on a connection set to 30 seconds timeouts. Client side logging indicated that 4 days elapsed between submitting the query and receiving the timeout. The client and the server were both running as part of the same virtual machine. The root cause was fairly evident: the virtual machine, having been suspended over several days, synchronized its system time via NTP and jumped 4 days ahead in time and the system time adjustment propagated to SQL Server just as it was executing the unfortunate query. However, this incident got us thinking. **Can transitions to daylight saving time cause random query timeouts, by spuriously adding 1 hour to the measured execution time of the query?** **Can other time zone changes cause random query timeouts?** I am hoping that SQL Server would use UTC timestamps to detect query timeouts and thus be unaffected by time zone changes. But I am unable to find any documentation to this effect.
Asked by Jirka Hanika (182 rep)
May 2, 2022, 09:04 AM
Last activity: May 2, 2022, 04:28 PM