Finding Last Used Stored Procedure in SQL Server

Hello everyone,

In this article, I will try to give information about finding the last used Stored Procedure in SQL Server.

In SQL Server in some cases you may want to find the last used Stored Procedure.

You can easily do this using the script below.

SELECT DB_NAME(qt.[dbid]) AS [DatabaseName],
       OBJECT_NAME(qt.[objectid], qt.[dbid]) AS [SP Name],
       qs.execution_count AS [Execution Count],
       qs.max_logical_reads,
       qs.max_logical_writes,
       qs.creation_time,
       DATEDIFF(MINUTE, qs.creation_time, GETDATE()) AS [Age in Cache]
FROM sys.dm_exec_query_stats AS qs
    CROSS APPLY sys.dm_exec_sql_text(qs.[sql_handle]) AS qt
WHERE LEN(OBJECT_NAME(qt.[objectid], qt.[dbid])) > 0
ORDER BY DB_NAME(qt.[dbid]) DESC,
         OBJECT_NAME(qt.[objectid], qt.[dbid]) DESC;

When you run the above code, you will see a result similar to the one below.

As you can see, we have found the Stored Procedure we used last time.

Good luck to everyone in business and life.