Besides using SQL Server Profiler, is there any way to track which stored procedures are being used, or at least when they were last executed?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
You can look in the plan cache to get a pretty good idea of Stored Procedure usage. Take this query, for instance:
This will give you the
Note: the plan cache contains the execution plans. This retention of these plans has many factors involved. Whereas this will give you a good idea of what is being used and how often, it's definitely not the running total of stored procedures and how often/when they were executed.
You can have a look at this as well as it contains info of