Issues and troubleshooting

High CPU usage on database

Occasionally when investigating resource-consuming SQL statements running on your system, you may find that some of them belong to the dbWatch application.

For example, a SQL statement that has the highest value of spent CPU time. In most cases, dbWatch executes the same SQL statements many times over a long time period so the accumulated CPU time becomes high, and at first glance this might be assumed to indicate a problem. However, if you calculate how much CPU time is consumed during a day, you will typically find that it is a matter of minutes.

Trouble with report generation on Linux

Some linux installation without X installed will have trouble generating reports.

To solve this create two files called:

• dbWatchConsole[version].vmoptions
• dbWatchService[version].vmoptions

where version is the dbWatch version (this should be identical to the name of the executable file).
Theese files should contain one line:
-Djava.awt.headless=true

Save and restart the dbWatch Server.