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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?