Timeshare Workload Access Levels - 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

The Pre-Migration Tool uses a mapping scheme to assign timeshare workloads one of four access level values based on allocation group relative weight values in SLES 10.

SLES 10 Allocation Group Relative Weight SLES 11 Access Level
> 10% Top
> 5% to 10% High
> 2% to 5% Medium
0 to 2% Low

Access level affects access rate (that is, resource volume received by a query) at a ratio of 2:1. So queries running in a timeshare workload of a given access level receive twice the resource volume as queries running in a timeshare workload of the access level immediately below.

Access Level Access Rate
Top 8
High 4
Medium 2
Low 1

Use the Pre-Migration tool to change the access level value automatically assigned to each timeshare workload for each planned environment, if necessary to meet priority-scheduling goals. To minimize required changes to individual workload access level values, adjust the mapping scheme of relative weight values to access level values for each planned environment as a first step.