Provides list of recent SQL statements that were received and handled by Lyftron. Includes internally generated statements like default federator call-backs.

Column name Data type Nullable? Description
id guid false Statement id.
time datetime2 false Statement start date.
user nvarchar(128) true User identity name.
sql_text nvarchar(max) true SQL statement text.
status nvarchar(128) true Statement status: Executing, Errored, or Finished.
duration time true Statement duration.
connection_id smallint true Internal connection id.


Select 10 longest requests recently processed:

select top 10
       time, user, sql_text, status, duration, connection_id
  from sys.lyft_recent_statements
    by duration desc