The allocation percentage assigned to SLG workloads should be high enough to ensure a reasonable distribution of resources to SLG workloads in comparison to timeshare workloads. In general, avoid low single-digit values for SLG allocation percentage. In addition, consider the following characteristics of SLG workloads:
- The percentage assigned to a workload represents an allocation of the resources flowing to its tier rather than an allocation of total system resources.
- The volume of resources provided to a workload based on allocation percentage is divided among concurrent queries running in the workload.
After upgrading to SLES 11 and monitoring the outcome of your original settings, you can adjust SLG workload allocation percentages as necessary using the Workload Designer portlet in Teradata Viewpoint. Before doing so, however, consider that the SLG tier should be reserved for highly critical workloads that consume few resources. If some workloads that you have associated with the SLG tier are less critical to the business than others, consider moving those workloads to the Top access level of the Timeshare tier.