Audit Stored Procs for Active Use

Last Post 18 Jan 2006 07:44 AM by SQL_Jr. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
SQL_Jr
New Member
New Member

--
18 Jan 2006 06:25 AM
hi, forum:

I am looking for a method yo audit the use of an app's stored proc use. We want to clean up non-used stored procs, as there are several that we can delete, and only a handful of actively used SPs. Is there a way to capture the last used date for each user SP? Can syscacheobjects help? Are there any scripts out there to do this? Any thoughts and advice is appreciated to do this. THX!
SQL_Jr
New Member
New Member

--
18 Jan 2006 07:44 AM
It would be hard to determine that "certain period of time" and to run profiler an indefinate amt of time on the prod box, would probably affect performance. Any other ideas?


Acceptable Use Policy
---