Using the Guided Workflow

The guided workflow enables you to test the performance effect of any types of system changes on a SQL workload, as listed in "SQL Performance Analyzer".

To use the SQL Performance Analyzer task guided workflow:

1. On the Software and Support page, under Real Application Testing, click SQL Performance Analyzer.

   The SQL Performance Analyzer page appears.

2. Under SQL Performance Analyzer Workflows, click Guided Workflow.

   The Guided Workflow page appears.

   The guided workflow enables you to test the performance effect on a SQL workload when you perform any type of system changes, as described in "SQL Performance Analyzer".

   This page lists the required steps in the SQL Performance Analyzer task in sequential order. Each step must be completed in the order displayed before the next step can begin.

3. On the Guided Workflow page, click the Execute icon for the Step 1: Create SQL Performance Analyzer Task based on SQL Tuning Set.

   The Create SQL Performance Analyzer Task page appears.

4. In the Name field, enter the name of the task.

5. In the Description field, optionally enter a description of the task.

6. Under SQL Tuning Set, in the Name field, enter the name the SQL tuning set that contains the SQL workload to be analyzed.

   Alternatively, click the search icon to select a SQL tuning set from the Search and Select: SQL Tuning Set window.

7. Click Create.

   The Guided Workflow page appears.

   The Status icon of this step has changed to a check mark and the Execute icon for the next step is now enabled.

8. Once the analysis task is created, you can build the pre-change performance data by executing the SQL statements stored in the SQL tuning set, as described in Creating a Pre-Change SQL Trial.