Thursday, January 14, 2021

Recently Executed queries

 SELECT

    txt.TEXT AS [SQL Statement],

    qs.EXECUTION_COUNT [No. Times Executed],

    qs.LAST_EXECUTION_TIME AS [Last Time Executed], 

    DB_NAME(txt.dbid) AS [Database]

FROM SYS.DM_EXEC_QUERY_STATS AS qs

    CROSS APPLY SYS.DM_EXEC_SQL_TEXT(qs.SQL_HANDLE) AS txt

ORDER BY qs.LAST_EXECUTION_TIME DESC

No comments:

Post a Comment

Recently Executed queries

 SELECT     txt.TEXT AS [SQL Statement],     qs.EXECUTION_COUNT [No. Times Executed],     qs.LAST_EXECUTION_TIME AS [Last Time Executed],   ...