Loading

To find recently executed queries in SQL Server

Venkatesan Jayakantham

Comments

Join the conversation! Your thoughts help the community grow.

To find recently executed queries,

Select dmStats.last_execution_time as 'Last Executed Time',dmText.text as 'Executed Query' from sys.dm_exec_query_stats as dmStats Cross apply sys.dm_exec_sql_text(dmStats.sql_handle) as dmText Order By
dmStats.last_execution_time desc

Cheers,

Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/