Results analysis and tuning

Here are some suggestions for analyzing the running Adaptive Server environment after you configure the execution hierarchy:

  1. Run the same benchmark tests you ran before assigning the execution attributes, and compare the results to the baseline results. See “Environment analysis and planning”.

  2. Ensure that there is good distribution across all the available engines using Adaptive Server Monitor or sp_sysmon. Check the “Kernel Utilization” section of the sp_sysmon report.

    Also see “Application management”.

  3. If the results are not what you expected, take a closer look at the interactions between execution objects.

    As described in “Environment analysis and planning”, look for inappropriate assumptions and dependencies that you might have missed.

  4. Make adjustments to the performance attributes.

  5. Finetune the results by repeating these steps as many times as necessary.