Query to check last couple of queries ran on SQL server

Tapan Patel
Aug 05 2016
Code

This is a basic query which retrieves data from the view and help developers/DBA to get last couple of queries ran on that SQL server. It is a SQL select joining over function that return Table when passed valid SQL Handle.

SELECT qs.last_execution_time AS [Time],
fst.TEXT AS [Query] FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS fst
ORDER BY qs.last_execution_time DESC