|
Workload Attributes
|
Name
|
Name for the new WD. Although not required, typically these begin with the prefix “WD-” for easy identification. |
|
Description
|
Description identifying this WD. |
|
Log Query Detail
|
Select this option to specify detailed logging of each query to DBQLogTbl. |
|
Enforcement Priority
|
- Tactical – Short queries with a fixed response-time requirement.
- Priority – Important queries that should get extra resources.
- Normal – Normal queries; this is the default.
- Background – Low-priority queries with no response-time requirement.
|
|
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
|
Maximum number of rows in a spool file or final result. |
|
IO Count
|
Maximum number of disk I/Os performed on behalf of the query. |
|
Spool Size
|
Maximum size of a spool file in B. |
|
Blocked Time
|
Length of time the query is blocked by another query. |
|
Elapsed Time
|
Length of time the query has been running. |
|
Number of Amps
|
Number of AMPs that participate in the query. |
|
Sum Over All Nodes
|
Total amount of CPU time (in hundredths of seconds) the query consumes over all nodes. |
|
Tactical CPU Usage Threshold (per node)
|
Per-node threshold of CPU usage for tactical workloads that, when exceeded, triggers exception handling. |
|
Qualification
Time
|
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
|
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
|
Integer value corresponding to the percentage of this workload which you expect to meet the service-level criteria. |
|
Arrival Rate per hour
|
Integer value corresponding to the number of queries that you expect to be received hourly. |
|
Throughput per hour
|
Integer value corresponding to the number of queries that you expect to be executed hourly. |
|
CPU seconds per query
|
Integer value corresponding to the processor time (in seconds) that you expect to be required for executing each query. |
|
Query Limits
|
State
|
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
|
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. |