Perceived bad performance of the STEP system is seldom the result of a single cause. Usually, a wide range of improvements, in a variety of areas, will result in an improved performance of the system. Therefore, it is impossible to predict which recommendations will result in a particular performance improvement percentage.
Note: Optimizing one area of the system may negatively affect performance in another area. Consider system-wide testing before and after making optimization changes to verify the end result meets your expectations.
This section includes the following recommended data gathering methods and performance improvement tactics:
- Performance assessment involves analyzing the system from a performance perspective, identifying the pain points, and giving actionable recommendations to optimize performance (here).
- Performance troubleshooting involves methods defined to troubleshoot performance issues (here).
- Technical performance recommendations involve client computers, internet connection, and STEP application and database server setup and connections (here).
- Functional performance recommendations involve configuring the data mode and the recommended use of application features (here).
- Healthcheck performance recommendations involve identifying and resolving system and performance issues. The tests available are defined in the Healthcheck section of the Administration Portal documentation (here).
- Monitoring performance recommendations involve managing the status of external systems used to process data as well as identify possible problem areas of the STEP application server. The monitoring sensors available are defined in the Monitoring section of the Administration Portal documentation (here).
Additionally, the In-Memory Database Component for STEP allows the system to take advantage of the availability of inexpensive memory to read all data into memory, and then read data from the In-Memory database instead of querying Oracle. For more information, see the In-Memory Database Component for STEP topic in the Resource Materials section of online help here.