Identify performance problems

This section provides information about how to isolate performance problems, collect statistics about the database schema, and troubleshoot performance problems.

Isolating Performance Problems

The section Configuring or Reconfiguring the Database and PPM Configuration parameters contain information on the initial settings that We recommend for the Oracle database and PPM Server.

If performance slows after these settings are in place, use the methods outlined in the flowcharts shown in Figure 7-1, Figure 7-2, and Figure 7-3 to isolate performance problems and determine how to fix them.

Figure 7-1. Identifying and addressing system performance problems

Figure 7-2. Identifying and addressing database performance problems (A)

Figure 7-3. Identifying and addressing Java process performance problems (B)

Figure 7-4. Identifying and addressing I/O performance problems (C)

Common Performance Problems

This section provides information about common performance problems and how to correct them. If you are not using the default or recommended settings, reset your parameters to those values before you try other solutions.

Tip: Consider upgrading to the latest PPM service pack. PPM has a regular and well-established service pack release cycle. Much of the development effort that goes into these service packs is focused on resolving known performance issues. Review the Release Notes for the latest service pack to determine whether it addresses the performance problem you are experiencing.

Performance Troubleshooting Toolkit

When you encounter performance issues when using PPM, you can open the following URLs without logging on to PPM. These URLs generates performance related information to help further solve the issues.

URL What does the URL do Where the jsp files are stored
http://<BASE_URL>/itg/html/toolkit/cpu.jsp Identify the most CPU-intensive thread. <PPM_HOME>\server\<NODE NAME>\deploy\itg.war\html\toolkit
http://<BASE_URL>/itg/html/toolkit/dump.jsp Generate the heap dump and thread dump automatically.
http://<BASE_URL>/itg/html/toolkit/mem.jsp Check the usage of heap.
http://<BASE_URL>/itg/html/toolkit/transaction.jsp Check the connection pool and transaction.