By
Published: 05 Oct 2005
I'd like to know if there is a way to calculate the exact size of a database aside from checking the database properties -> info tab. What I am doing right now is going to the All documents view and totaling the size of all the documents. Next I run database mail\xxx.nsf to total the size of the indexes. I assume that if I add these two, I should get the total size of the database, but it is varying for me. We are running on a Windows server.
No. This addition will not show you the total size of the database. There are all sorts of other things in the database, besides documents and views. Also, Notes databases always include some amount of "whitespace" which is used for database expansion, without having to request more disk space.
The problem is that "size of the database" is not well defined. If you want to know the number of documents, check the info tab. If you want to know the number of views, and their sizes, use the SHOW DATABASE command you mentioned. If you want to know how much disk space the database takes, use Windows Explorer.
Do you have comments on this Ask the Expert question and response? Let us know.
Dig Deeper on Lotus Notes Domino Database Management
Learn how to change authentication timeout interval for Domino Web Access logins.
Continue Reading
SearchDomino.com expert Chuck Connell helps a Lotus Domino administrator troubleshoot a "File truncated – file may have been damaged" error ...
Continue Reading
This administrator has a replication issue between two servers in two domains. Front-end replication works fine, but when replication is initiated ...
Continue Reading