Adventures of a Software Engineer

Show last executed query SQL Server – Disected

Written by

greg

in

I found this online, without explanation so I will dissect the query and explain what is happening.

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

This beautifully crafter query will show us last few queries executed on they db, very usefull for seeing what is Hibernate generating for us.

Comments

One response to “Show last executed query SQL Server – Disected”

  1. a Avatar
    a

    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

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

More posts