Virtually testing the acceleration of SQL statements

You can perform virtual tests that are based on the recommendations of the Workload Analytics Acceleration Advisor, and virtual tests to help you determine which tables you can remove from an accelerator.

Before you begin

About this task

Use this page for the following tasks:
  • Test variations of recommendations from the Workload Analytics Acceleration Advisor
  • Test how much removing tables from an accelerator will affect the performance of a query workload
Attention: When you start a test, the advisor follows one of these sets of steps:
  • If profiles are active on the subsystem, the advisor creates and enables a profile to use during the test, and then issues the START PROFILE command. All profiles that were deactivated are reactivated, including the profile that the advisor created. After running the test, the advisor removes the profile that the advisor used during the test, and then issues the START PROFILE command again to reactivate all of the enabled profiles.
  • If profiles are not active on the subsystem, the advisor creates and enables a profile to use during the test, and then the advisor issues the START PROFILE command. All profiles for which PROFILE_ENABLED is set to Y in the profile table are activated. After running the test, the advisor issues the STOP PROFILE command and removes the profiles that the advisor used during the test.

Procedure


Feedback