Sample Header Ad - 728x90

create_time in sys.dm_xe_sessions is in the future

0 votes
1 answer
171 views
I have run the following query which shows the running XE sessions on the server: SELECT name, create_time FROM sys.dm_xe_sessions and I get the results +-------------------------------+-------------------------+ | name | create_time | +-------------------------------+-------------------------+ | hkenginexesession | 2020-01-04 06:39:14.240 | | system_health | 2020-01-04 06:39:14.313 | | Deadlocks | 2020-01-04 06:39:14.483 | | sp_server_diagnostics session | 2020-01-04 06:39:14.583 | | Blocked Processes | 2019-11-20 14:27:49.593 | +-------------------------------+-------------------------+ Note that the first four sessions, 3 of which are system, 1 of which is user created (Deadlocks) have a create_time in the future. I can verify the system time is correct doing a simple SELECT GETDATE() The Blocked Processes xe session has been created since the last server restart (which was 2019-11-15 13:36:35.287) What could have caused this? SQL Server Version is Microsoft SQL Server 2014 (SP3-CU4) (KB4500181) - 12.0.6329.1 (X64) Jul 20 2019 21:42:29 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor)
Asked by SE1986 (2192 rep)
Dec 11, 2019, 09:19 AM
Last activity: Jun 15, 2023, 05:04 PM