Q
Get started Bring yourself up to speed with our introductory content.

Calculating size of database

This Lotus Notes user wants to know how to calculate the exact size of a database.

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.

This was last published in October 2005

Dig Deeper on Lotus Notes Domino Database Management

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchExchange

SearchContentManagement

Close