Start of Content Area

Procedure documentation Identifying Problems with All Transactions Running Slow (Informix)  Locate the document in its SAP Library structure

Use

This procedure tells you how to identify problems that affect all users. If the problem only affects certain users, see Identifying Problems with One Transaction Running Slow (Informix).

Procedure

  1. Run a basic health check on your database, as described in SAP/Informix Performance Monitoring.
  2. Check the wait situations.

This shows you the state of the database threads. Ideally, the threads should spend more time "running" than in other states. If mt yield n or ready is at the top of the list, you might need to add CPU virtual processors (VPs) to the system. If you see AIO at the top of the list, see if you can speed up or reduce the quantity of your I/O. You might need to tune your application to improve the situation.

For more information, see:
  1. If your system normally runs satisfactorily but appears to be slowing down due to a high processing load, check which session – and, therefore, which user and program – is responsible for the most load. Sometimes a single poor program can negatively impact performance for all users.

For more information, see: