Kbase P25863: AppServer takes 100% CPU when running job.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
AppServer takes 100% CPU
It only occurs for the time needed to process a job.
After the job is completed, the AppServer process does not take 100% CPU any longer.
Shared memory connection.
Java and OS versions are compatible with Progress.
CAUSE:
The most likely cause for seeing 100% CPU usage is that the 4GL programs are not using indexes correctly, or that your databases has not got the appropriate indexes.
FIX:
Ensure that your application is using the indexes correctly.
You can start investigating in this direction by compiling programs and adding the XREF option to the COMPILE statement; by analyzing the output of XREF, ensure that the indexes that your programs are using, are the ones that you expect.
Alternatively you can add USE-INDEX to all your FOR EACH, FIND, OPEN QUERY statements.