Link to home
Start Free TrialLog in
Avatar of kamar
kamar

asked on

What is the best and easiest way to identify unused databases in the server

I have over 12 application servers and each has more than a hundred databases.  What is the best way for me to easily identify at a glance which has not been opened or use by any users anymore?  
Avatar of qwaletee
qwaletee

The catalog shows the last modified date of the database, and the number of times the database was accessed by users in the last day, week, and month.  You can build custom views in the catalog to show you this.
ASKER CERTIFIED SOLUTION
Avatar of qwaletee
qwaletee

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Also, watch out for non-replica catalogs.  You probably want to make sure all your catalogs are replicas of each other, so you don;t have tolook at separate catalogs for each server.
Do you need additional assistance with this?