Identifying Unused Stored Procedures

Posted in 2011

DONALD KORTHAUER — Mon, 18 Apr 2011 15:52:19 — source: IIUG Forums & Mailing Lists

I've been requested to find out how many of our 3000 stored procedures actually get used and how many have not been touched in 24 months. Any suggestions? Thanks!

↪ replying to DONALD KORTHAUER

Joerg Volz — Mon, 18 Apr 2011 17:29:18 — source: IIUG Forums & Mailing Lists

Add a line where that just writes "SPL xyz called at time and date" into a new table? Joerg Volz ------------------------------------------------------------------------ ----- -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of DONALD KORTHAUER Sent: Monday, April 18, 2011 6:01 PM To: ids@iiug.org Subject: Identifying Unused Stored Procedures [23442] I've been requested to find out how many of our 3000 stored procedures actually get used and how many have not been touched in 24 months. Any suggestions? Thanks! ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. IT Handel und Beratung Jorg Volz Bernhard-Fruh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de