Starting or Stopping Database Analyzer
Database Analyzer is a database tool for analyzing database performance.
-
You are logged on to the database as database system administrator or as a DBM operator with server authorization for using Database Analyzer.
More information: Glossary, Server Permission
-
The database is in the ONLINE operational state.
-
Select the database in the explorer tree.
-
In the context menu of the database, choose Administration.
-
Open the Overview tab page.
-
Choose Database Analyzer.
-
To start Database Analyzer, choose Activate Database Analyzer and specify the start options.
Property
Description
Interval
Time interval between two analyses
Default value: 900 s
Number
Number of analyses to be performed
Configuration file
Name of the configuration file to be used
If you do not specify a configuration file, Database Analyzer uses the dbanalyzer<version>.cfg file in the <installation_path>\env directory.
You can display the installation path using the dbm_getpath DBM command: dbmcli dbm_getpath InstallationPath
More information: Database Analyzer, Database Analyzer Configuration File
Delete Logs
Delete Database Analyzer log files
To change options, specify the new options and choose Restart Database Analyzer.
To stop Database Analyzer, choose Deactivate Database Analyzer.
Database Analyzer writes its messages to the following log files.
|
File Name |
Directory |
Content |
|---|---|---|
|
DBAN.prt |
<run_directory>\analyzer\<date> For more information, see Run Directory. |
Database Analyzer log files |
|
DBAN.inf |
<run_directory>\analyzer |
Database Analyzer status |
|
DBAN.err |
<run_directory>\analyzer |
Database Analyzer errors |
|
Further Database Analyzer Log Files |
- |
- |
|
Index accesses Index range accesses Isolated index accesses Isolated index range accesses Isolated index scans More information: Optimizer Strategies |
|
Primary key accesses Primary key range accesses More information: Optimizer Strategies |