May 12, 2005 at 4:25 am
Hi All,
I am pretty new in SQL server 2000 Administration. I have 3 SQL SERVER and each of them has more then 30 Databases. There are lot of applications previously developed which uses them. I cannot map which application using which database and by which user. I know some of the databases are absolutely of no use but I can’t find a way to find them. There is more then 300 user of these databases. Is there any way or free tool that can help me here?
Your feedback will be highly appreciated.
-Saif
May 12, 2005 at 6:13 am
I'd be looking to do something in profiler to monitor activity in each DB and the NT username/login being used.
You'd probably need to leave it running for quite a while to catch them all and I'd probably expect logins to access more than one DB.
Rather than delete the databases straight off you'd be better taking them offline, that way when/if you find that you've made a mistake you can bring them back online without worrying too much.
Hope this helps
May 13, 2005 at 7:19 am
Profiler is very useful but it produces a lot of output, you will have to experiment with the filters to produce useful results. Maybe do a few databases at a time, use the dbid in the Filter, thses can be obtained from master..sysdatabases or the db_id function.
If there are some databases that you are pretty sure are not used I wouldn't bother with Profiler. Take them offline for a week (set them to DBO use only & Read Only) then back them up and delete them. Then set up some control procedures!
May 13, 2005 at 9:07 am
I like Peter's suggestion. It is easy to undo if something isn't working. Be sure that you let the others know what you've done if they might get calls about application issues.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply