Understanding SLG Tier and Timeshare Workload Information - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

System Workload Report (SLES 11 only)

Supplemental SLG tier and timeshare workload information is displayed in the System Workload Report, accessed from the Workload Distribution tab. This report shows resource distribution percentages for the SLG tier and timeshare workloads. Reported values are based upon no activity in tactical workloads.

The following columns display:

Workload
Displays workloads by name, except for tactical workloads.
Virtual Partition
Virtual partition to which each workload belongs.
Tier
Tier to which each workload belongs. The following naming convention for timeshare workloads enables better sorting results:
  • TS1 = Top timeshare
  • TS2 = High timeshare
  • TS3 = Medium timeshare
  • TS4 = Low timeshare
% of Tier
Percent of resources, out of 100% of the tier resources, that is available to each workload.
% of System
Percent of resources, out of 100% of total system resources, that is available to each workload. This percentage changes with the addition of or change to WM COD.
% of System
Bar charts representing the value in the % of System column. The scale of the bars is relative to the tier with the highest percentage. The highest percentage bar uses the full width of the column.
% of WM COD
Percent of resources within the amount that WM COD makes available. This setting does not change when WM COD is introduced or undergoes change.
If WM COD is set to 100%, WM COD percentage information will not appear in the System Workload Report.


Filters and Table Actions

Filters
Shows only rows that match your filter criteria. A second click reverses the sort order. Sort on two columns consecutively by sorting the first column and then using Ctrl+Click once in the column header of the second column. Using Ctrl+Click one time sets the secondary sort order. Primary sort order is indicated by a single arrow, and secondary sort order is indicated by a double arrow.

Upon opening the report, a primary ascending sort order is placed, by default, on the Virtual Partition column and a secondary ascending sort order on the Tier column. The secondary sort order on the Tier column is removed when the primary or secondary sort column has been modified. After modification, you see a single arrow to indicate the secondary sort order has been removed.

Table Actions
  • Clear Filters removes any content in the filter boxes.
  • Export creates a .csv file containing all available data.

For more information, see Summary Table Controls.

Workload Distribution View Balloons

An information balloon appears when you hover over a workload or unallocated resources in the Workload Distribution view.

Workload balloons show information about the resources available to the workload:

Percent of tier
Percent of resources, out of 100% of the tier resources, that is available to that workload
Percent of system
Percent of resources, out of 100% of total system resources, that is available to that workload. This percentage changes with the addition of or change to WM COD
Percent of WM COD
Percent of resources within the amount that WM COD makes available. This setting does not change when WM COD is introduced or undergoes change
Hard limit
Maximum percent of the system resources allowed for this workload so that it cannot exceed its allocation and deprive lower tiers and workloads of system resources
SLG expedite
Specifies whether SLG expedite is enabled for a workload. This appears in the balloon only when the feature is enabled

Balloons for unallocated resources show information about the resources available to lower tiers and Timeshare workloads:

Percent of tier
Percent of resources, out of 100% of tier resources not allocated to workloads, that is available to workloads in lower tiers or timeshare. Ten percent of tier resources is always reserved to prevent SLG Tier workloads from depriving Timeshare workloads of all resources
Percent of system
Percent of system resources that are not allocated within the tier, that is available to workloads in lower tiers or timeshare
Percent of WM COD
Percent of resources within the amount that WM COD makes available and that is not allocated within the tier, that is available to workloads in lower tiers or timeshare