Recently Executed Queries in Database

In this blog we will see how to a fetch list of the recently executed queries.

Introduction

If we want to fetch a list of the recently executed queries, we need to write the given below query. This will fetch the executed time and query.

SELECT

    deqs.last_execution_time AS [Time],

    dest.TEXT AS [Query]

 FROM

    sys.dm_exec_query_stats AS deqs

    CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest

ORDER BY

    deqs.last_execution_time DESC

It will give the result like this :