Analyzing performance

When there are performance problems, you need to determine the sources of the problems and your goals in resolving them. The steps for analyzing performance problems are:

  1. Collect performance data to get baseline measurements. For example, you might use one or more of the following tools:

  2. Analyze the data to understand the system and any performance problems. Create and answer a list of questions to analyze your Adaptive Server environment. The list might include questions such as:

  3. Define system requirements and performance goals:

  4. Define the Adaptive Server environment—know the configuration and limitations at all layers.

  5. Analyze application design—examine tables, indexes, and transactions.

  6. Formulate a hypothesis about possible causes of the performance problem and possible solutions, based on performance data.

  7. Test the hypothesis by implementing the solutions from the last step:

  8. Use the same tests used to collect baseline data in step 1 to determine the effects of tuning. Performance tuning is usually a repetitive process.

  9. If testing shows that your hypothesis is correct, implement the solution in your development environment.