Home > Ask the Domino Experts > Spam and Security Questions & Answers > Calculating size of database
Ask The Domino Expert: Questions & Answers
EMAIL THIS

Calculating size of database

Chuck Connell EXPERT RESPONSE FROM: Chuck Connell

Pose a Question
Other Domino Categories
Meet all Domino Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 08 September 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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Spam and Security
Can I encrypt an email sender's name?
Changing timeout intervals for Domino Web Access authentication
Putting a stop to incoming spam on Lotus Notes 6.5
Restoring a corrupt Lotus Notes certlog.nsf file
Troubleshooting a constantly corrupting names.nsf file
Lotus Notes replication snafu: Accidentally deleted archived email
Getting past expired IDs
Creating a single sign-on for .NET and Lotus Notes
Error restoring an NSF archive file: 'File truncated - file may have been damaged'
Setting corporate mail file size policies on NSF files

Lotus Notes Domino Database Management
LotusScript code rebuilds corrupted busytime.nsf file
LotusScript agent automates selective mail file replication
Configuring Domino Domain Monitoring (DDM)
How to move Notes databases off Domino 8 servers and save disk space
What is Notes 8.5's DAOS (Domino Attachment and Object Storage) feature?
LotusScript agent indexes Lotus Notes/Domino databases
An introduction to Domino Domain Monitoring (DDM)
'Customize this view' options are disabled in Lotus Notes databases
LotusScript button saves time searching large Lotus Notes databases
Batch file runs scheduled Lotus Notes database maintenance tasks

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


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.




Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Lotus Notes Domino on Blackberry and mobile devices
HomeTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts