Workload classification criteria cannot be manually modified from the Classification tab of the Workload Attributes window. You can, however, add more classification criteria using the Split option.
- Right-click the workload in the list on the left side of the Workload Attributes window.
- Click Split from the right-click menu.. The Split Workloads dialog box appears. For details on the fields used for splitting workloads, see splitting Splitting Workloads.
- Click Add New Classification. The Classification tab appears, similar to the tab of the same name on the Workload Attributes window, however all functionality is enabled.
- Select the Choose another selection criteria check box. The --AND-- pane of the tab becomes visible, showing the Criteria #2 drop-down list. The list includes the items shown as check boxes in the Category pane of the Define DBQL Inputs dialog.
- Select Data Objects from the Criteria #2 list of the Classification tab. For more information, see Defining or Modifying Classification Criteria #2–6 for a WD.
- Click Choose.
-
From the Classify by Data Object dialog box, click Choose from the Object Type drop-down list, and then select the type of data object to be used for classification from one of the following:
- Database
- Table
- View
- Macro
- Stored Procedure
- Function
- Method
- Click Load to display all items that can be used as attributes for the selected data object.
-
From the Available list, select the items you want to include as attributes and click Include.
Use the Shift and Ctrl keys to select multiple consecutive or non-consecutive attributes. To move an attribute back to the Available list, select it and click Remove.
- From the Available list, select the attributes to exclude and click Exclude.
- When finished, click OK to return to the Classification tab and select additional criteria.