You can monitor the SQL Performance Analyzer data captured in the task, and the pre-change and post-change trials, and comparisons.

In addition, you can create multiple trials and comparisons within the task to test other system changes on SQL performance.

To monitor a SQL Performance Analyzer task:

1. Go to the SQL Watch home page for the database.
2. In the Tasks section, click the name of the task.

The SQL Performance Analyzer Task: <name of the task> panel is displayed and has the following tabs:

• Executions: On this tab, you can:
  • Monitor the details of the most recent execution
  • Monitor the trials created as part of the task
  • Monitor the comparisons created as part of the task
  • Create trials and comparisons for the task
• Comparison explorer: On this tab, you can monitor how the SQL performance of a reference trial compares with changed trials, based on the performance metrics selected for the comparison analysis.