Comparing current performance data with an older set of data

You can compare the current performance data with a saved set of performance data or with a set that you imported.

Before you begin

The performance metrics columns must be visible in the SQL Outline view. Click the arrow on Show or Hide Columns (Show or Hide Columns) and select Performance Columns.

Procedure

To compare the current performance data with another data set:

  1. At the top of the SQL Outline view, select the type of performance data from Performance Data Type.
  2. Select the Compare check box.

    If you are currently viewing a saved Workbench SQL performance data set when you click the Compare check box, the SQL Outline view reverts to showing the current performance data set.

  3. In the field to the right of the Compare check box, select the set of performance data that you want to compare with the other set. This data set can be one that you saved yourself or one that you imported.

Results

Each of the columns shows the data split into two halves. The left half, which is gray, shows the data from the current performance data set. The right half shows the data from the data set with which you are making the comparison.

Use the Show field to choose how to display the comparison of the data in the sets. These are the choices:

Value
In each column, the result from the first data set appears on the left. The result from the second data set appears on the right.
Difference
In each column, the result from the first data set appears on the left. The value that appears on the right in each column is A-B, where A is the result from the first data set and B is the result from the second data set.
Percentage
In each column, the result from the first data set appears on the left. The value that appears on the right in each column is (A-B)/A, where A is the result from the first data set and B is the result from the second data set.

If you want to sort the results, click Show tree view or table view to view the results in a table. Then, select the Sort by check box and click the headings for the columns by which you want to sort the data. The values that appear on the right in the selected columns are sorted.


Feedback