Exceptions result when threshold values for the designated criteria are exceeded. Disk and skew criteria also require that the condition persist for a specified amount of time before an exception is triggered.
You can define an exception by specifying the values (and qualification time, if applicable) for the following criteria.
Name | Description |
---|---|
Maximum Spool Rows | The maximum number of rows that a query step can spool. Enter the maximum allowable number. |
Spool Usage | The amount of spool space, per step, that a query uses. Enter the maximum value and select B (bytes), KB (kilobytes), MB (megabytes), or GB (gigabytes). |
Number of AMPs | The number of AMPs that participate in a query. Enter the maximum number. |
Blocked Time | The length of time a query is blocked by another query. Enter the maximum time in the format hhh:mm:ss (hours:minutes:seconds). |
Elapsed Time | The length of time a query has been running (the response time). Enter the maximum amount in the format hhh:mm:ss (hours:minutes:seconds). By default the amount of time you enter includes blocked and throttle delay time. (Teradata Database 15.10 and later) You can exclude them by selecting the Exclude blocked time and Exclude throttle delay time check boxes. |
I/O Count | The number of disk I/Os performed for the query. Enter the maximum number. |
CPU Time (sum over all nodes) | The amount of CPU processing time consumed by a query, summed over all the nodes used. Enter the maximum time in CPU-seconds. |
CPU Skew Percent | The percentage difference in CPU consumption between the busiest AMP and the average of all involved AMPs during the last exception interval. Enter the maximum percentage and the qualification time in CPU-seconds. |
I/O Skew Percent | The percentage difference in disk I/O counts between the busiest AMP and the average of all involved AMPs during the last exception interval. Enter the maximum percentage and the qualification time in CPU-seconds. |
CPU Skew Difference | The difference in CPU consumption between the busiest AMP and the average of all involved AMPs during the last exception interval. Enter the maximum amount of time and the qualification time in CPU-seconds. |
I/O Skew Difference | The difference in disk I/O counts between the busiest AMP and the average of all involved AMPs during the last exception interval. Enter the maximum value and the qualification time in CPU-seconds. |
CPU Disk Ratio | The ratio of CPU consumption to disk I/O during the last exception interval. Enter the maximum ratio and the qualification time in CPU-seconds. |
I/O Physical Bytes | The amount of I/O space, summed over all nodes, that a query consumes. Enter the maximum I/O physical bytes, select KB (kilobytes), MB (megabytes), or GB (gigabytes), and enter the qualification time in CPU-seconds. |