Use DBSTATS to get statistical information on the databases on the server and can be run from Query Tool. It will show Database Name, Status ( NOT_LOADING / LOADING / LOADED ), Estimated Memory Usage, Time Loaded, Time Created, Disk Size when loaded, Latest File Created and Latest File Size.
This is useful to manage memory usage and the load status of databases to reduce memory consumption on the server.
Example:
Comments
Please sign in to leave a comment.