Use DBSTATS to get statistical information on the databases on the server and can be run from both import scripts and 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.

  • No labels