question

zillabaug avatar image
zillabaug asked

How can I identify unused or seldomly used stored procs in sql server 2000?

I'm currently in the preparatory stages of migrating my SQL Sever 2000 to SQL Server 2014.I would like to identify all stored procs that have never been called or used and purge them before migration. Does anyone have an idea as to how to accomplish this task? Can someone point me in the right direction.
sql-server-2008-r2sql-server-2000migrationarchiving
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
David Wimbush avatar image
David Wimbush answered
If they aren't preventing the upgrade, I would leave them alone for now. I would get the upgrade done and use the greatly improved DMVs in SQL 2014 to identify unused procs after the upgrade has bedded in.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

zillabaug avatar image zillabaug commented ·
thanks David!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.