Database analysis
You can perform a database analysis to collect information about one or more databases from a variety of sources -- the replication history, the User Activity dialog box, and the log file (LOG.NSF) -- and view it in a single "results" database. You can perform a database analysis only if you have access to the Domino® Administrator.
Use database analysis to collect the following information about a database:
- Replication history, as recorded in the Replication History dialog box
- User reads and writes, as recorded in the User Activity dialog box (one way of viewing database activity statistics generated by the Statlog task)
- Document creations, edits, and deletions, as recorded in a database
- Design changes, as recorded in a database
- Replication additions, updates, and deletions, as reported in the log file
- Mail messages delivered by the mail Router
You can collect this information from multiple replicas of a database.
When you perform a database analysis, you create a database that holds the results, which are stored in analysis documents. After you create a results database, each time you perform a database analysis, you can choose to overwrite its contents or append new results to its contents. The results database is created from the Database Analysis (DBA4.NTF) template.
Each analysis document in the results database contains fields that describe a particular event.
Field |
Describes |
---|---|
Date |
Date of the event |
Time |
Time of event |
Source of Event Information |
The analyzed database or its replicas or the log file |
Source Database |
Name of a database containing documents that were read For database replication events, name of database from which information was pulled |
Source |
Name of server that stores a database containing documents that were read or written For database replication events, name of server that stores the database from which information was pulled |
Destination |
Name of a database on which documents were updated For database replication, name of the database to which information was replicated |
Destination machine |
Name of a server that stores a database that was updated For database replication, name of a server that stores a database to which information is replicated |
Description |
Description of the event |
Analysis documents describe these types of events:
Event |
Describes |
Required database analysis option |
---|---|---|
Activity |
Number of user or server reads and writes generated by the Statlog task when monitoring database activity |
User reads User writes |
+Activity |
Number of user reads and writes as noted in the database and in the log file |
Log file activity User reads or User writes |
Mail Router |
Number of documents delivered to the database |
User writes |
Data Note |
Document creations, edits, and deletions |
Changes to documents |
Design Note |
Changes to the database ACL and design |
Changes to design |
Replicator |
Replication history |
Replication history |
+Replicator |
Number of replication additions, updates, and deletions, as reported in the log file |
Log file activity |