When databases are going wild and are becoming unreasonable slow and the rebuild of view indexes takes quite a long while it is time to review the space view indexes are taking.

There is an easy way to display view statistics in the Domino Administrator client. Right-clicking to a database and selecting Manage Views comes up with a statistic similar to this:

But how many times have you been asked whether this information can be exported/mailed/printed? Unfortunately this isn’t a feature of the Domino Administrator yet. You can however retrieve the view information using the

show database path\filename.nsf

command on the server console. Without any parameter Show Database will display both, database and document information as well as view size statistics. Alternatively the output can be restricted using the d parameter (without a dash) to only display database and document information or v to display view information only.

While this still doesn’t export the information yet, you could either extract the information from the log.nsf or redirect the display to a file. The command

show database names.nsf v >c:\views.txt

will export the view information of the names.nsf to a local file views.txt on the C:\ drive on the server.

This entry was posted on Monday, February 4th, 2008 at 1:56 pm and is filed under Administration, Lotus Notes. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.