In the next release of Performance Analyzer for Microsoft Dynamics (DynamicsPerf), we will be making a schema change to the AX_SQLTRACE table. Currently, the [CREATED_DATETIME] column is stored in GMT time. Dynamics AX stores it this way to adjust for clients being in multiple time zones.
So, in our next release, we will be adjusting [CREATED_DATETIME] to be the time zone that SQL Server is in. This should make reading the data in this table much easier as it will now match the time zone of all other date columns in the DynamicsPerf database. Thus, we’ll be able to answer the question, “What time is it?”
Here is the query that is changing: