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.

To start Database Analyzer, choose Database Analyzer and specify the start options.

Database Analyzer: 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 `<dependent_path>/env/` database directory. 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.

Database Analyzer Log Files
File Name	Directory	Content
`DBAN.prt`	`<independent_data_path>\wrk\analyzer`	Database Analyzer log files
`DBAN.inf`	`<independent_data_path>\wrk\analyzer`	Database Analyzer status
`DBAN.err`	`<independent_data_path>\wrk\analyzer`	Database Analyzer errors
Further Database Analyzer Log Files	-	-

Database Analyzer: Messages
Avg User cmd exec Time for Task
Avg User Suspend Time for Task
Avg User Wait Time For Task
Catalog Cache Hit Rate
Collision Rate
Data Cache Hit Rate
Data Volume Filling Level
Deletes/Updates
Free User Tasks
Index accesses Index range accesses Isolated index accesses Isolated index range accesses Isolated index scans More information: Optimizer Strategies
Log Area Filling Level
Lock List Escalations
Log Queue Overflows
Log write time
Max Log Queue Filling
Number of Cached History Pages
Number of Physical Reads
Number of Physical Writes
Number of Physical Writes of Temporary Pages
OMS Cache Hit Rate
OMS Heap Collisions
OMS Heap Utilization
OMS History Cache Hit Rate
OMS Terminates
OMS Version is Old
OMS Version is Unloaded
Out of Memory Exceptions
Parse Activities
Physical Reads for User Task
Primary key accesses Primary key range accesses More information: Optimizer Strategies
Selects and Fetches
Table scans
User Task Blocked in State
User Task Physical Writes