DATABASE MANAGEMENT


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

How the Statlog task generates activity statistics

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. This table compares the information generated in each location.
Information providedDatabase Activity Log entryUser Activity dialog box
Shows 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*YesYes
Shows inactive views (indicated by the size 0)YesNo
Shows names of users and servers who read and wrote documents, sorted by date*NoYes
* Includes activity for anonymous and authenticated Internet clients.

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 topics