Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
milind_dabhole
Starting Member
1 Post |
 Posted - 2005-02-11 : 11:44:36
|
| we have got bit complex and not-managed-properly database and many applications surrounding those databases. unfortunately now there are number of tables, stored procs, views that are not used. but we don't know which. how do we know which ones are never called say for a period of 30 days etc. is there a db admin activity that can be carried out which will tell me object A accesses/utilised zero times ? or something similar ? it shall be of great use if u can shed some light. we use sql server 2000 on windows 2000 many thanks |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-02-11 : 12:20:58
|
I have a similarly disorganized database(s) so I just added a custom bit of tracking to the sprocs.It grabs the @@procId, startTime, endtime, and the parameter listI then archive the summary information after 7 days (aka totals and averages per sproc)Corey "If the only tool you have is a hammer, the whole world looks like a nail." - Mark Twain |
 |
|
|
|
|
|
objects not in use in SQL Server