Calculating SLG Workload Allocation Percentage - Teradata Database - Teradata Viewpoint

Workload Pre-Migration User Guide

Product
Teradata Database
Teradata Viewpoint
Published
January 2016
Language
English (United States)
Last Update
2018-05-07
dita:mapPath
yfc1467307781404.ditamap
dita:ditavalPath
ft:empty
dita:id
scv1467244925615
Product Category
Analytical Ecosystem
Software

To calculate SLG workload allocation percentage, complete the following steps.

  1. Establish a baseline allocation percentage for the SLG workload based on its CPU usage at peak consumption.
  2. Estimate the combined CPU usage at peak processing times for tactical workloads.
  3. Adjust the baseline allocation percentage of the SLG workload to reach a final allocation percentage as follows:
    1. Subtract the current combined peak CPU usage value for all tactical workloads from 100 to establish the CPU percentage remaining after tactical workloads use the resources they require.
    2. Establish an initial adjusted allocation percentage for the SLG workload by dividing its baseline allocation percentage by the value resulting from the preceding step, that is, the CPU percentage remaining after tactical workloads use the resources they require.
    3. Finalize the adjusted allocation percentage for the SLG workload by adding 5 or more percentage points to ensure that the workload is always given higher priority than any of the timeshare workloads.
      This last adjustment may be particularly important when a workload's baseline allocation percentage is a single-digit value.