When was stored procedure last run

Improve this answer. Roelant 3, 1 1 gold badge 23 23 silver badges 52 52 bronze badges. Pixelated Pixelated 1, 3 3 gold badges 15 15 silver badges 35 35 bronze badges. It not show all stored procedure show only last run stored procedure — user In a nutshell, no. However, there are "nice" things you can do.

The tried-and-tested "see who calls" method of IT support. I first used "see who calls" to find extra ports on a terminal controller. The following excerpts are from Books Online for the given dm views… sys. Jeff Moden Jeff Moden 2, 1 1 gold badge 23 23 silver badges 19 19 bronze badges. So would it be fair to say that if an entry is present in the query offered by Pixelated then the last execution time is accurate, but if an entry is missing then you can make no assumptions about its last execution time?

My apologies for the extremely late answer. I haven't been around here much lately. What you stated above is correct. Naruto Naruto 8 8 silver badges 17 17 bronze badges.

Alexander Sharovarov Alexander Sharovarov 1 1 silver badge 5 5 bronze badges. Martin Smith Martin Smith k 80 80 gold badges silver badges bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook.

Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. Certainly as a guideline use DMVs though they only show history since last server restart however don't use this alone. Question We starting to get a lot of stored procedures in our application. In a nutshell, no. However, there are "nice" things you can do. The tried-and-tested "see who calls" method of IT support. The following excerpts are from Books Online for the given dm views… sys.

Get answers to millions of questions and give back by sharing your knowledge with others. This means you would at least need a max to get a "right" value.

I have not done any testing, but it seems to me that when the create date and last-run date equal one another, then the stored proc has not been run since the date it was initially created. This may be something you care to pursue to answer your question. The view returns one row for each cached stored procedure plan, and the lifetime of the row is as long as the stored procedure remains cached.

When a stored procedure is removed from the cache, the corresponding row is eliminated from this view. You can add a stored procedure to the cache as simply as invoking it. BusinessEntityID ,Person. FirstName ,Person.

LastName ,Employee. JobTitle from AdventureWorks Employee inner join AdventureWorks Person on Employee. Related Articles. Simple process to track and log SQL Server stored procedure use. Finding SQL Server objects that reference invalid objects. Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data. How to tell what SQL Server versions you are running. Resolving could not open a connection to SQL Server errors. Ways to compare and find differences for SQL Server tables and data.

Searching and finding a string value in all columns in a SQL Server table. View all my tips. Back To Top Cheers, Rick Dobson. Beside of these things, really nice article. Hey Daniel, Here's another thought that I wanted to share with you.