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?
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.