Working with Workload Attributes
After a workload is analyzed, you can view and modify details about the workload, such as workload period and service level goals.
Note: Avoid modifying workload classifications using the following procedure with New Workload Recommendations or Existing Workload Analysis as changes made on the tabbed dialogs will not be reflected in the Workloads Report.
To view workload attributes
1 From the Candidate Workload Report window, click the + sign to the left of the workload whose attributes you want to view. The candidate workload listing expands in the tree.
2 Click Attributes. The Workload Attributes window appears.
3 Click the appropriate tab to view workload attributes, classifications, exceptions, service level goals and query limits as described in Table 1.
Tab |
Option |
Description |
Workload Attributes
|
Name |
A name for the new WD. Although not required, typically these begin with the prefix “WD-” for easy identification. |
Description |
A description identifying this WD. |
|
Log Query Detail |
Select this option to specify detailed logging of each query to DBQLogTbl. |
|
Enforcement Priority |
|
|
Classification |
Criteria #1 |
Selects the classification criteria. |
Includes |
Displays the selected objects within the chosen criteria |
|
Choose |
Allows inclusion and exclusion of strings within the chosen criteria. |
|
Choose another selection criteria |
Adds another classification criteria, with its own pull-down and object list. |
|
Accept |
Accepts the changes made to the Classification tab. |
|
Restore |
Undoes changes to the classification criteria. |
|
Show |
Creates a report of the classification criteria that maybe saved, printed, or both. |
|
Exception |
Maximum Rows |
The maximum number of rows in a spool file or final result. |
IO Count |
The maximum number of disk I/Os performed on behalf of the query. |
|
Spool Size |
The maximum size of a spool file in B. |
|
Blocked Time |
The length of time the query is blocked by another query. |
|
Elapsed Time |
The length of time the query has been running. |
|
Number of Amps |
The number of AMPs that participate in the query. |
|
Sum Over All Nodes |
The total amount of CPU time (in hundredths of seconds) the query consumes over all nodes. |
|
Tactical CPU Usage Threshold (per node) |
The per-node threshold of CPU usage for tactical workloads that, when exceeded, triggers exception handling. |
|
Qualification |
The length of time the exception condition must persist before an action is triggered (in seconds). |
|
IO Skew |
Based on the Qualification Time, the maximum difference in disk I/O Counts between the least busy and most busy AMP. |
|
CPU Skew |
Based on the Qualification Time, the maximum difference in CPU consumption (in seconds) between the least busy and the most busy AMP. |
|
CPU millisec per IO |
Based on the Qualification time, the maximum ratio of CPU consumption to disk I/O during the last exception interval. |
|
IO Skew Percent |
Based on the Qualification Time, the percentage difference in disk I/O Counts between the least busy and the most busy AMP. |
|
CPU Skew Percent |
Based on the Qualification Time, the percentage difference in CPU consumption between the least busy and the most busy AMP. |
|
Service Level Goals |
|
|
Operating Environment |
Lists the operating environment that the workload is currently in. The default is Always. |
|
Response Time |
A response-time value in hours, minutes, and seconds. This is the maximum amount of time that you expect to be required for completion of this workload. |
|
Service Percent |
An integer value corresponding to the percentage of this workload which you expect to meet the service-level criteria. |
|
Arrival Rate per hour |
An integer value corresponding to the number of queries that you expect to be received hourly. |
|
Throughput per hour |
An integer value corresponding to the number of queries that you expect to be executed hourly. |
|
CPU seconds per query |
An integer value corresponding to the processor time (in seconds) that you expect to be required for executing each query. |
|
Query Limits |
State |
The current state of default or base. |
Override Default |
Select this option to override the default limit for each state specified. When you select this option Unlimited is activated. |
|
Unlimited |
The default option when Override Default is selected. |
|
Limit |
Select this option to define a new limit. |
|
Reject |
Select this option to reject over-limit queries for a particular state, otherwise over-limit queries are delayed. |