Monitoring database activity
Monitor database activity regularly. If database activity is high and users report performance problems, do any of the following:
- Set database properties that improve performance.
- Create a replica of the database on another server, if possible, one within a server cluster.
- Move the database to a more powerful server.
- Move the database to a disk that is less heavily used, or if it's a large database, to its own disk.
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 provided |
Appears in Database Activity Log entries |
Appears 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. |
Yes |
Yes |
| Inactive views (indicated by the size 0) |
Yes |
No |
| Names of users and servers who read and wrote documents, sorted by date. Includes activity for anonymous and authenticated Internet clients. |
No |
Yes |
For information on File Monitor documents, the Event Monitor task, monitoring Web site activity, and monitoring database activity within a server cluster, see Domino® Administrator Help.