APPLICATION MANAGEMENT

Monitoring database activity
Monitor database activity regularly. If database activity is high and users report performance problems, do any of the following:
Consider deleting an inactive database or view to free disk space on the server.

How the Statlog task generates activity statistics

The Statlog task runs by default once a day at 5 AM to report database activity on the server. The information appears as Database Activity Log entries in the Database - Usage and Database - Sizes views of the log file (LOG.NSF) and in the User Activity dialog box of individual databases. The Statlog task also reports database size statistics in the Database - Sizes view of the log file.

This table compares the information generated in each location.

Information providedAppears in Database Activity Log entriesAppears in User Activity dialog box
Total number of times user and servers accessed, read, and wrote to a database in past 24 hours, past week, past month, and since the creation of the database.

Includes activity for anonymous and authenticated Internet clients.

YesYes
Inactive views (indicated by the size 0)YesNo
Names of users and servers who read and wrote documents, sorted by date.

Includes activity for anonymous and authenticated Internet clients.

NoYes

Tip In addition to viewing activity statistics reported by Statlog, you can evaluate database activity by creating a view that sorts documents by date. You can also create File Monitor documents as part of Event Monitor configuration. File Monitors report user activity for specific databases.

For information on File Monitor documents, the Event Monitor task, monitoring Web site activity, and monitoring database activity within a server cluster, see Lotus Domino Administrator Help.

See Also