ADMINISTERING
Monitor database activity regularly. If database activity is high and users report performance problems, you can take a number of steps to improve performance.
The Statlog task on a server runs by default once a day at 5 AM, at which time it reports database activity for databases on the server in Database Activity Log entries in the Database -> Usage and Database -> Sizes views of the log file (LOG.NSF) and to the User Activity dialog box of individual databases.
Table 1. Comparison of information provided by Database Activity Log entry and User Activity dialog box
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.
Note: The Statlog task also reports database size statistics in the Database -> Sizes view of the log file.
Related concepts Moving databases
Related tasks Viewing database activity statistics generated by the Statlog task Managing database activity recording in databases
Related reference Database properties that optimize database performance Notes database activity logging