patternsqlMinor
Official Source of What Time Zone an XEvent is Logged
Viewed 0 times
zonewhatsourcexeventtimeloggedofficial
Problem
I'm trying to prove that extended events (hence audits as well) are logged in UTC time zone and can't be changed but I can't find an official source. I've searched Microsoft's pages and SQL Server 2012 book but couldn't find anything official regarding this topic, only answers on forums. Could anyone point to an official source?
Solution
I can't find anything official in the documentation either.
But I've previously blogged about this here: Extended Events Timezones
It boils down to an experiment:
Confirming that the data is stored in the UTC format.
But I've previously blogged about this here: Extended Events Timezones
It boils down to an experiment:
- Running a SQL Server in a different timezone.
- Looking at the data stored with sys.fn_xe_file_target_read_file
Confirming that the data is stored in the UTC format.
Context
StackExchange Database Administrators Q#320956, answer score: 5
Revisions (0)
No revisions yet.