Static Pipes View - Teradata Viewpoint - Teradata Workload Management

The Static Pipes view displays all workloads and indicates how many are active.

Toolbar

Navigation Icons: You can click them to access the summary views.

Ruleset: Displays the name of the active ruleset.

State Matrix: Shows the changes in state, planned environment, or health condition during the cumulative sampling time frame. In SLES 11, you can click it to see details about the current state and previous states.

Request Icons: Shows the active and delayed requests. You can click them to see more detail.

Sampling Time Frame Control

Filters the system information for the selected sampling time frame.

Virtual Partition List

In SLES 11, filters the system information for the selected virtual partition or all virtual partitions.

Request Status Icons

Shows the number of requests processed at each step, including at system filters and throttles. You can click the values associated with these icons to see more detail.

Tabs

Workloads: Displays metrics for all workloads within the last sampling time frame. You can click a workload name to access the Workload Pipe view and see cumulative, snapshot, and trend data for each workload.

Enforcement Priorities: In SLES 10, displays summary data about all active workloads, aggregated across all EPs. Available metrics include the total number of active requests classified into one or more workloads in the EP, number of completed requests within the EP, average CPU time, and percentage of workloads that met their SLGs.

Tier/Access Level: In SLES 11, displays summary data about all active tiers and access levels for the selected virtual partition. Available metrics for each tier/access level include total number of active requests, number of completed requests, average CPU time, and the percentage of queries in the tiers/access levels that met their SLGs.

Table Actions

Click to select the columns displayed on the Workloads, Enforcement Priorities, and Tier/Access Level tabs. You can also select Export to create a .csv file containing the information displayed in the summary table.

For more information, see Summary Table Controls.

Workload Name

Shows the workload name. You can click it to show the workload details view and access cumulative, snapshot, and trend data for each workload.