HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Official Source of What Time Zone an XEvent is Logged

Submitted by: @import:stackexchange-dba··
0
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:

  • 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.