Results analysis and tuning

After you configure the execution hierarchy, analyze the running Adaptive Server environment:

  1. Run the same benchmark tests you ran before assigning the execution attributes, and compare the results to the baseline results.

  2. Use Adaptive Server Monitor or sp_sysmon to ensure there is good distribution across all the available engines. Check the “Kernel Utilization”. See Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon.

  3. If the results are not what you expected, take a closer look at the interactions between execution objects. Look for inappropriate assumptions and dependencies that you might have missed.

  4. Make adjustments to performance attributes.

  5. Fine-tune the results by repeating these steps as many times as necessary to monitor your environment over time.