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
Last activity: Jun 15, 2023, 05:04 PM