lyft_recent_statements – Lyftron

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.

Example

Select 10 longest requests recently processed:

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

{[{category.name}]}

Example