The documentation says that the "Attention" extended event class has StartTime and EndTime as part of it.
But I can't seem to figure out how to get at it or record it...
Here is what I am using to create the event session:
CREATE EVENT SESSION [TimeoutMonitor] ON SERVER ADD EVENT sqlserver.attention( ACTION(sqlserver.client_app_name,sqlserver.client_hostname,sqlserver.database_id, sqlserver.database_name,sqlserver.is_system,sqlserver.nt_username,sqlserver.server_principal_name, sqlserver.sql_text,sqlserver.username)) -- Save to our file. Max size of 500 megabites and 3 rollover files (so it can take up 1.5 GB total) ADD TARGET package0.event_file(SET filename=N'd:\TimeoutMonitoring\TimeoutMonitor.xel', max_file_size=500, max_rollover_files=3)
But if I try to add
sqlserver.start_time (or any variant like
StartTime) I get an error.
And if I try to query as if it is just automatically recorded, I also get an error.
Is there a way to get start time and end time for Attention Events?