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.

Finding Last Used Stored Procedure in SQL Server

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

Good luck to everyone in business and life.

72 Views

Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!